{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/admin/anaconda/envs/python3.6/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2862: FutureWarning: \n", "mpl_style had been deprecated and will be removed in a future version.\n", "Use `matplotlib.pyplot.style.use` instead.\n", "\n", " exec(code_obj, self.user_global_ns, self.user_ns)\n" ] } ], "source": [ "# The usual preamble\n", "%matplotlib inline\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "\n", "# Make the graphs a bit prettier, and bigger\n", "pd.set_option('display.mpl_style', 'default')\n", "\n", "# This is necessary to show lots of columns in pandas 0.12. \n", "# Not necessary in pandas 0.13.\n", "pd.set_option('display.width', 5000) \n", "pd.set_option('display.max_columns', 60)\n", "\n", "plt.rcParams['figure.figsize'] = (15, 5)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We're going to use a new dataset here, to demonstrate how to deal with larger datasets. This is a subset of the of 311 service requests from [NYC Open Data](https://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9). " ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stderr", "output_type": "stream", "text": [ "/Users/admin/anaconda/envs/python3.6/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2698: DtypeWarning: Columns (8) have mixed types. Specify dtype option on import or set low_memory=False.\n", " interactivity=interactivity, compiler=compiler, result=result)\n" ] } ], "source": [ "complaints = pd.read_csv('../data/311-service-requests.csv')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Depending on your pandas version, you might see an error like \"DtypeWarning: Columns (8) have mixed types\". This means that it's encountered a problem reading in our data. In this case it almost certainly means that it has columns where some of the entries are strings and some are integers.\n", "\n", "For now we're going to ignore it and hope we don't run into a problem, but in the long run we'd need to investigate this warning." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 2.1 What's even in it? (the summary)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "When you print a large dataframe, it will only show you the first few rows.\n", "\n", "If you don't see this, don't panic! The default behavior for large dataframes changed between pandas 0.12 and 0.13. Previous to 0.13 it would show you a summary of the dataframe. This includes all the columns, and how many non-null values there are in each column." ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
02658965110/31/2013 02:08:41 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1143290-03 169 STREET169 STREET90 AVENUE91 AVENUENaNNaNADDRESSJAMAICANaNPrecinctAssigned10/31/2013 10:08:41 AM10/31/2013 02:35:17 AM12 QUEENSQUEENS1042027.0197389.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.708275-73.791604(40.70827532593202, -73.79160395779721)
12659369810/31/2013 02:01:04 AMNaNNYPDNew York City Police DepartmentIllegal ParkingCommercial Overnight ParkingStreet/Sidewalk1137858 AVENUE58 AVENUE58 PLACE59 STREETNaNNaNBLOCKFACEMASPETHNaNPrecinctOpen10/31/2013 10:01:04 AMNaN05 QUEENSQUEENS1009349.0201984.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.721041-73.909453(40.721040535628305, -73.90945306791765)
22659413910/31/2013 02:00:24 AM10/31/2013 02:40:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant100324060 BROADWAYBROADWAYWEST 171 STREETWEST 172 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 10:00:24 AM10/31/2013 02:39:42 AM12 MANHATTANMANHATTAN1001088.0246531.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.843330-73.939144(40.84332975466513, -73.93914371913482)
32659572110/31/2013 01:56:23 AM10/31/2013 02:21:48 AMNYPDNew York City Police DepartmentNoise - VehicleCar/Truck HornStreet/Sidewalk10023WEST 72 STREETWEST 72 STREETCOLUMBUS AVENUEAMSTERDAM AVENUENaNNaNBLOCKFACENEW YORKNaNPrecinctClosed10/31/2013 09:56:23 AM10/31/2013 02:21:10 AM07 MANHATTANMANHATTAN989730.0222727.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.778009-73.980213(40.7780087446372, -73.98021349023975)
42659093010/31/2013 01:53:44 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsVacant Lot10027WEST 124 STREETWEST 124 STREETLENOX AVENUEADAM CLAYTON POWELL JR BOULEVARDNaNNaNBLOCKFACENEW YORKNaNNaNPending11/30/2013 01:53:44 AM10/31/2013 01:59:54 AM10 MANHATTANMANHATTAN998815.0233545.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.807691-73.947387(40.80769092704951, -73.94738703491433)
52659237010/31/2013 01:46:52 AMNaNNYPDNew York City Police DepartmentNoise - CommercialBanging/PoundingClub/Bar/Restaurant1137237 AVENUE37 AVENUE84 STREET85 STREETNaNNaNBLOCKFACEJACKSON HEIGHTSNaNPrecinctOpen10/31/2013 09:46:52 AMNaN03 QUEENSQUEENS1016948.0212540.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.749989-73.881988(40.7499893014072, -73.88198770727831)
62659568210/31/2013 01:46:40 AMNaNNYPDNew York City Police DepartmentBlocked DrivewayNo AccessStreet/Sidewalk11419107-50 109 STREET109 STREET107 AVENUE109 AVENUENaNNaNADDRESSSOUTH RICHMOND HILLNaNPrecinctAssigned10/31/2013 09:46:40 AM10/31/2013 01:59:51 AM10 QUEENSQUEENS1030919.0187622.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.681533-73.831737(40.68153278675525, -73.83173699701601)
72659519510/31/2013 01:44:19 AM10/31/2013 01:58:49 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11417137-09 CROSSBAY BOULEVARDCROSSBAY BOULEVARDPITKIN AVENUEVAN WICKLEN ROADNaNNaNADDRESSOZONE PARKNaNPrecinctClosed10/31/2013 09:44:19 AM10/31/2013 01:58:49 AM10 QUEENSQUEENS1027776.0184076.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.671816-73.843092(40.67181584567338, -73.84309181950769)
82659054010/31/2013 01:44:14 AM10/31/2013 02:28:04 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant10011258 WEST 15 STREETWEST 15 STREET7 AVENUE8 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:44:14 AM10/31/2013 02:00:56 AM04 MANHATTANMANHATTAN984031.0208847.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.739913-74.000790(40.73991339303542, -74.00079028612932)
92659439210/31/2013 01:34:41 AM10/31/2013 02:23:51 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11225835 NOSTRAND AVENUENOSTRAND AVENUEUNION STREETPRESIDENT STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 09:34:41 AM10/31/2013 01:48:26 AM09 BROOKLYNBROOKLYN997941.0182725.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.668204-73.950648(40.66820406598287, -73.95064760056546)
102659517610/31/2013 01:25:12 AMNaNNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship112183775 18 AVENUE18 AVENUEEAST 9 STREETEAST 8 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctOpen10/31/2013 09:25:12 AMNaN14 BROOKLYNBROOKLYN992726.0170399.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.634378-73.969462(40.63437840816299, -73.96946177104543)
112659198210/31/2013 01:24:14 AM10/31/2013 01:54:39 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10003187 2 AVENUE2 AVENUEEAST 11 STREETEAST 12 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:24:14 AM10/31/2013 01:54:39 AM03 MANHATTANMANHATTAN988110.0205533.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.730816-73.986073(40.73081644089586, -73.98607265739876)
122659416910/31/2013 01:20:57 AM10/31/2013 02:12:31 AMNYPDNew York City Police DepartmentIllegal ParkingDouble Parked Blocking VehicleStreet/Sidewalk1002965 EAST 99 STREETEAST 99 STREETMADISON AVENUEPARK AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:20:57 AM10/31/2013 01:42:05 AM11 MANHATTANMANHATTAN997470.0226725.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.788974-73.952259(40.78897400211689, -73.95225898702977)
132659439110/31/2013 01:20:13 AMNaNNYPDNew York City Police DepartmentNoise - VehicleEngine IdlingStreet/Sidewalk10466NaNNaNNaNNaNSTRANG AVENUEAMUNDSON AVENUEINTERSECTIONBRONXNaNPrecinctOpen10/31/2013 09:20:13 AMNaN12 BRONXBRONX1029467.0264124.0UnspecifiedBRONXUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.891517-73.836457(40.89151738488846, -73.83645714593568)
142659091710/31/2013 01:19:54 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Mixed Use Building1121963 STREET63 STREET13 AVENUE14 AVENUENaNNaNBLOCKFACEBROOKLYNNaNNaNPending11/30/2013 01:19:54 AM10/31/2013 01:29:26 AM10 BROOKLYNBROOKLYN984467.0167519.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.626477-73.999218(40.6264774690411, -73.99921826202639)
152659145810/31/2013 01:14:02 AM10/31/2013 01:30:34 AMNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship10025NaNNaNNaNNaNWEST 99 STREETBROADWAYINTERSECTIONNEW YORKNaNPrecinctClosed10/31/2013 09:14:02 AM10/31/2013 01:30:34 AM07 MANHATTANMANHATTAN992454.0229500.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.796597-73.970370(40.7965967075252, -73.97036973473399)
162659408610/31/2013 12:54:03 AM10/31/2013 02:16:39 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk10310173 CAMPBELL AVENUECAMPBELL AVENUEHENDERSON AVENUEWINEGAR LANENaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:54:03 AM10/31/2013 02:07:14 AM01 STATEN ISLANDSTATEN ISLAND952013.0171076.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.636182-74.116150(40.63618202176914, -74.1161500428337)
172659511710/31/2013 12:52:46 AMNaNNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11236NaNNaNNaNNaNROCKAWAY PARKWAYSKIDMORE AVENUEINTERSECTIONBROOKLYNNaNPrecinctOpen10/31/2013 08:52:46 AMNaN18 BROOKLYNBROOKLYN1015289.0169710.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.632437-73.888173(40.63243692394328, -73.88817263437012)
182659038910/31/2013 12:51:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaNNaN226 42 ST E42 ST ECHURCH AVESNYDER AVENaNNaNADDRESSNaNNaNNaNOpenNaNNaNUnspecified BROOKLYNBROOKLYNNaNNaNUnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
192659421010/31/2013 12:46:27 AMNaNNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10033NaNNaNNaNNaNWEST 184 STREETBROADWAYINTERSECTIONNEW YORKNaNPrecinctAssigned10/31/2013 08:46:27 AM10/31/2013 01:32:41 AM12 MANHATTANMANHATTAN1002294.0249712.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.852058-73.934776(40.85205827756883, -73.93477640780834)
202659293210/31/2013 12:43:47 AM10/31/2013 12:56:20 AMNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship11216778 PARK PLACEPARK PLACEROGERS AVENUENOSTRAND AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 08:43:47 AM10/31/2013 12:56:20 AM08 BROOKLYNBROOKLYN997608.0184656.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.673505-73.951844(40.67350473678714, -73.95184414979961)
212659415210/31/2013 12:41:17 AM10/31/2013 01:04:37 AMNYPDNew York City Police DepartmentNoise - CommercialBanging/PoundingStore/Commercial10016155 E 34TH STE 34TH STNaNNaNNaNNaNLATLONGNEW YORKNaNPrecinctClosed10/31/2013 08:41:17 AM10/31/2013 01:04:38 AM06 MANHATTANMANHATTAN990133.0211136.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.746194-73.978769(40.74619417253121, -73.97876853124392)
222658967810/31/2013 12:39:55 AMNaNNYPDNew York City Police DepartmentNoise - VehicleCar/Truck MusicStreet/Sidewalk11419NaNNaNNaNNaN112 STREETATLANTIC AVENUEINTERSECTIONSOUTH RICHMOND HILLNaNPrecinctOpen10/31/2013 08:39:55 AMNaN09 QUEENSQUEENS1030314.0191578.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.692394-73.833891(40.69239424979043, -73.8338912453996)
232659230410/31/2013 12:38:00 AMNaNNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11216371 TOMPKINS AVENUETOMPKINS AVENUEMADISON STREETPUTNAM AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctAssigned10/31/2013 08:38:00 AM10/31/2013 01:16:53 AM03 BROOKLYNBROOKLYN999720.0188825.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.684944-73.944221(40.6849442562592, -73.94422078036632)
242659189210/31/2013 12:37:16 AMNaNNYPDNew York City Police DepartmentBlocked DrivewayPartial AccessStreet/Sidewalk103051496 BAY STREETBAY STREETLYMAN AVENUESCHOOL ROADNaNNaNADDRESSSTATEN ISLANDNaNPrecinctAssigned10/31/2013 08:37:16 AM10/31/2013 12:52:10 AM01 STATEN ISLANDSTATEN ISLAND967283.0160518.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.607245-74.061106(40.60724493456944, -74.06110566015863)
252659157310/31/2013 12:35:18 AM10/31/2013 02:41:35 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1031224 PRINCETON LANEPRINCETON LANEHAMPTON GREENDEAD ENDNaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:35:18 AM10/31/2013 01:45:17 AM03 STATEN ISLANDSTATEN ISLAND929577.0140964.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.553421-74.196743(40.55342078716953, -74.19674315017886)
262659050910/31/2013 12:33:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaNNaN38 ST E38 ST ECHURCH AVELINDEN BLVDNaNNaNBLOCKFACENaNNaNNaNOpenNaNNaNUnspecified BROOKLYNBROOKLYNNaNNaNUnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
272659137910/31/2013 12:32:44 AMNaNDOHMHDepartment of Health and Mental HygieneHarboring Bees/WaspsBees/Wasps - Not a beekeper3+ Family Mixed Use Building10025501 WEST 110 STREETWEST 110 STREETAMSTERDAM AVENUEBROADWAYNaNNaNADDRESSNEW YORKNaNNaNOpen11/30/2013 12:32:44 AMNaN09 MANHATTANMANHATTAN994143.0231888.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.803149-73.964266(40.80314938553783, -73.96426608076082)
282659408510/31/2013 12:32:08 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10026121 WEST 116 STREETWEST 116 STREETLENOX AVENUE7 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctAssigned10/31/2013 08:32:08 AM10/31/2013 02:00:57 AM10 MANHATTANMANHATTAN997947.0231613.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.802390-73.950526(40.80238950799943, -73.95052644123253)
292658920110/31/2013 12:32:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaN10309295 BAYVIEW AVENUEBAYVIEW AVENUEVAIL AVENUEBAYVIEW LANENaNNaNADDRESSSTATEN ISLANDNaNNaNOpenNaNNaN03 STATEN ISLANDSTATEN ISLAND927687.0127837.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.517378-74.203435(40.517377871705676, -74.20343466779575)
...............................................................................................................................................................
1110392642876410/04/2013 12:17:03 AM10/04/2013 12:38:37 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10022249 EAST 53 STREETEAST 53 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:17:03 AM10/04/2013 12:38:37 AM06 MANHATTANMANHATTAN993036.0215164.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757248-73.968286(40.757247604963055, -73.96828647941395)
1110402642616610/04/2013 12:16:22 AM10/04/2013 05:50:49 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyStore/Commercial10029252 EAST 110 STREETEAST 110 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:16:22 AM10/04/2013 05:50:49 AM11 MANHATTANMANHATTAN1000407.0228425.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.793635-73.941649(40.79363516179995, -73.94164859515777)
1110412643856510/04/2013 12:16:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN11231480 VAN BRUNT STREETVAN BRUNT STREETREED STREETDEAD ENDNaNNaNADDRESSBROOKLYNNaNNaNOpenNaNNaN06 BROOKLYNBROOKLYN979657.0184924.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.674249-74.016558(40.6742492231181, -74.01655803856313)
1110422642899010/04/2013 12:15:52 AM10/04/2013 12:44:52 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10014733 WASHINGTON STREETWASHINGTON STREETBANK STREETBETHUNE STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:15:52 AM10/04/2013 12:44:52 AM02 MANHATTANMANHATTAN981950.0207532.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.736304-74.008299(40.736303747410034, -74.00829935904578)
1110432643265910/04/2013 12:15:46 AM10/04/2013 04:18:45 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant112181213 CORTELYOU ROADCORTELYOU ROADEAST 12 STREETEAST 13 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:15:46 AM10/04/2013 04:18:45 AM14 BROOKLYNBROOKLYN993451.0172498.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640139-73.966847(40.64013899178716, -73.96684680242933)
1110442642609610/04/2013 12:14:09 AM10/04/2013 01:03:46 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10032539 WEST 162 STREETWEST 162 STREETST NICHOLAS AVENUEBROADWAYNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:14:09 AM10/04/2013 01:03:46 AM12 MANHATTANMANHATTAN1000571.0244054.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.836532-73.941018(40.836532082987944, -73.9410182995914)
1110452643776410/04/2013 12:14:00 AM10/04/2013 12:14:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022251 EAST 51 STREETEAST 51 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:14:00 AM06 MANHATTANMANHATTAN992791.0214702.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.755980-73.969171(40.75597977288785, -73.96917140638074)
1110462643628610/04/2013 12:14:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN11231480 VAN BRUNT STREETVAN BRUNT STREETREED STREETDEAD ENDNaNNaNADDRESSBROOKLYNNaNNaNOpenNaNNaN06 BROOKLYNBROOKLYN979657.0184924.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.674249-74.016558(40.6742492231181, -74.01655803856313)
1110472642898910/04/2013 12:13:08 AM10/04/2013 02:12:47 AMNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11434NaNNaNNaNNaNGUY R BREWER BOULEVARDROCKAWAY BOULEVARDINTERSECTIONJAMAICANaNPrecinctClosed10/04/2013 08:13:08 AM10/04/2013 02:12:47 AM13 QUEENSQUEENS1048801.0178419.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.656160-73.767353(40.656160351546845, -73.76735262738222)
1110482643003010/04/2013 12:12:07 AM10/04/2013 02:45:24 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10027215 WEST 131ST STREETWEST 131ST STREETNaNNaNNaNNaNLATLONGNEW YORKNaNPrecinctClosed10/04/2013 08:12:07 AM10/04/2013 02:45:24 AM01 MANHATTANMANHATTAN999107.0235603.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.813339-73.946328(40.81333907832113, -73.94632769228208)
1110492642966310/04/2013 12:12:07 AM10/04/2013 01:03:44 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant112098915 5 AVENUE5 AVENUE89 STREET90 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:12:07 AM10/04/2013 01:03:44 AM10 BROOKLYNBROOKLYN976525.0165015.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.619601-74.027826(40.619601147364584, -74.02782628492785)
1110502643776310/04/2013 12:11:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN10028NaNNaNNaNNaNEAST 84 STREETYORK AVENUEINTERSECTIONNEW YORKNaNNaNOpenNaNNaN08 MANHATTANMANHATTAN998629.0221493.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.774612-73.948085(40.77461174278734, -73.94808472177321)
1110512643295510/04/2013 12:08:15 AM10/04/2013 12:48:02 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10009506 EAST 13 STREETEAST 13 STREETAVENUE AAVENUE BNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:08:15 AM10/04/2013 12:48:03 AM03 MANHATTANMANHATTAN989678.0205065.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.729531-73.980416(40.72953107218499, -73.98041550317102)
1110522643703510/04/2013 12:08:00 AM10/04/2013 12:13:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022325 EAST 54 STREETEAST 54 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:13:00 AM06 MANHATTANMANHATTAN993688.0215099.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757069-73.965933(40.75706852462872, -73.96593314322774)
1110532643319710/04/2013 12:08:00 AM10/04/2013 12:00:00 PMDSNYBCC - Queens EastDerelict Vehicles14 Derelict VehiclesStreet11413220-11 145 AVENUE145 AVENUE221 STREET221 STREETNaNNaNADDRESSSpringfield GardensNaNDSNY GaragePendingNaN10/04/2013 12:08:00 AM13 QUEENSQUEENS1051511.0181411.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.664353-73.757556(40.6643525308449, -73.75755575708348)
1110542642606010/04/2013 12:06:39 AM10/04/2013 12:31:16 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk112244823 BEACH 48 STREETBEACH 48 STREETBODY OF WATERSURF AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:06:39 AM10/04/2013 12:31:16 AM13 BROOKLYNBROOKLYN980859.0149681.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.577515-74.012207(40.57751513866536, -74.01220705163807)
1110552643062810/04/2013 12:06:28 AM10/04/2013 12:21:39 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant112097915 3 AVENUE3 AVENUE79 STREET80 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:06:28 AM10/04/2013 12:21:39 AM10 BROOKLYNBROOKLYN976189.0168214.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.628381-74.029040(40.62838143294541, -74.02904041333245)
1110562643164810/04/2013 12:06:26 AM10/23/2013 08:14:52 AMDOTDepartment of TransportationStreet Sign - MissingBus StopStreet11378NaNNaNNaNNaN54 AVENUE43 STREETINTERSECTIONMASPETHNaNNaNClosed10/14/2013 09:38:47 AM10/23/2013 08:14:52 AM02 QUEENSQUEENS1005171.0206064.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.732250-73.924513(40.73225000573841, -73.92451289173367)
1110572643703410/04/2013 12:06:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Jack Hammering (NC2)NaN10036NaNNaNNaNNaNWEST 48 STREETBROADWAYINTERSECTIONNEW YORKNaNNaNOpenNaNNaN05 MANHATTANMANHATTAN988451.0216208.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.760116-73.984836(40.76011648520396, -73.98483562074706)
1110582642609410/04/2013 12:05:12 AM10/04/2013 01:08:29 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11237211 KNICKERBOCKER AVENUEKNICKERBOCKER AVENUEJEFFERSON STREETTROUTMAN STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:05:12 AM10/04/2013 01:08:29 AM04 BROOKLYNBROOKLYN1004672.0195540.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.703365-73.926345(40.703365329011284, -73.92634531031759)
1110592642904010/04/2013 12:04:52 AM10/04/2013 03:01:04 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1000399 2 AVENUE2 AVENUEEAST 5 STREETEAST 6 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:04:52 AM10/04/2013 03:01:04 AM03 MANHATTANMANHATTAN987393.0204234.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.727251-73.988660(40.727251287038676, -73.98866028603422)
1110602643408410/04/2013 12:04:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN10036NaNNaNNaNNaN8 AVENUEWEST 47 STREETINTERSECTIONNEW YORKNaNNaNOpenNaNNaN04 MANHATTANMANHATTAN987720.0216313.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.760405-73.987474(40.76040500039782, -73.98747426235285)
1110612642616410/04/2013 12:03:00 AM10/04/2013 02:14:57 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant1110630-09 BROADWAYBROADWAY30 STREET31 STREETNaNNaNADDRESSASTORIANaNPrecinctClosed10/04/2013 08:03:00 AM10/04/2013 02:14:57 AM01 QUEENSQUEENS1004746.0217004.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.762279-73.926013(40.762278541098084, -73.92601303458156)
1110622643971010/04/2013 12:03:00 AM10/04/2013 12:03:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022325 EAST 54 STREETEAST 54 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:03:00 AM06 MANHATTANMANHATTAN993688.0215099.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757069-73.965933(40.75706852462872, -73.96593314322774)
1110632643556910/04/2013 12:02:00 AM10/04/2013 01:10:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022311 EAST 50 STREETEAST 50 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 01:10:00 AM06 MANHATTANMANHATTAN993118.0214222.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.754662-73.967992(40.75466197318078, -73.96799173864807)
1110642642601310/04/2013 12:01:13 AM10/07/2013 04:07:16 PMDPRDepartment of Parks and RecreationMaintenance or FacilityStructure - OutdoorsPark11213NaNNaNNaNNaNNaNNaNNaNBROOKLYNNaNNaNClosed10/18/2013 12:01:13 AM10/07/2013 04:07:16 PM08 BROOKLYNBROOKLYNNaNNaNBrower ParkBROOKLYNBrower ParkB012NaNNaN7189658900Brooklyn, St. Marks, Kingston Avenues, Park PlaceBROOKLYNNY11213NNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1110652642808310/04/2013 12:01:05 AM10/04/2013 02:13:50 AMNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11434NaNNaNNaNNaNGUY R BREWER BOULEVARDROCKAWAY BOULEVARDINTERSECTIONJAMAICANaNPrecinctClosed10/04/2013 08:01:05 AM10/04/2013 02:13:50 AM13 QUEENSQUEENS1048801.0178419.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.656160-73.767353(40.656160351546845, -73.76735262738222)
1110662642898710/04/2013 12:00:45 AM10/04/2013 01:25:01 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10016344 EAST 28 STREETEAST 28 STREETMOUNT CARMEL PLACE1 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:00:45 AM10/04/2013 01:25:01 AM06 MANHATTANMANHATTAN990637.0208987.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.740295-73.976952(40.740295354643706, -73.97695165980414)
1110672642611510/04/2013 12:00:28 AM10/04/2013 04:17:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant112261233 FLATBUSH AVENUEFLATBUSH AVENUEAVENUE DNEWKIRK AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:00:28 AM10/04/2013 04:17:32 AM14 BROOKLYNBROOKLYN996654.0172515.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640182-73.955306(40.64018174662485, -73.95530566958138)
1110682642803310/04/2013 12:00:10 AM10/04/2013 01:20:52 AMNYPDNew York City Police DepartmentBlocked DrivewayPartial AccessStreet/Sidewalk112361259 EAST 94 STREETEAST 94 STREETAVENUE JAVENUE KNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:00:10 AM10/04/2013 01:20:52 AM18 BROOKLYNBROOKLYN1011804.0172470.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640024-73.900717(40.640024057399216, -73.90071711703163)
\n", "

111069 rows × 52 columns

\n", "
" ], "text/plain": [ " Unique Key Created Date Closed Date Agency Agency Name Complaint Type Descriptor Location Type Incident Zip Incident Address Street Name Cross Street 1 Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type City Landmark Facility Type Status Due Date Resolution Action Updated Date Community Board Borough X Coordinate (State Plane) Y Coordinate (State Plane) Park Facility Name Park Borough School Name School Number School Region School Code School Phone Number School Address School City School State School Zip School Not Found School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name Latitude Longitude Location\n", "0 26589651 10/31/2013 02:08:41 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11432 90-03 169 STREET 169 STREET 90 AVENUE 91 AVENUE NaN NaN ADDRESS JAMAICA NaN Precinct Assigned 10/31/2013 10:08:41 AM 10/31/2013 02:35:17 AM 12 QUEENS QUEENS 1042027.0 197389.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.708275 -73.791604 (40.70827532593202, -73.79160395779721)\n", "1 26593698 10/31/2013 02:01:04 AM NaN NYPD New York City Police Department Illegal Parking Commercial Overnight Parking Street/Sidewalk 11378 58 AVENUE 58 AVENUE 58 PLACE 59 STREET NaN NaN BLOCKFACE MASPETH NaN Precinct Open 10/31/2013 10:01:04 AM NaN 05 QUEENS QUEENS 1009349.0 201984.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.721041 -73.909453 (40.721040535628305, -73.90945306791765)\n", "2 26594139 10/31/2013 02:00:24 AM 10/31/2013 02:40:32 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10032 4060 BROADWAY BROADWAY WEST 171 STREET WEST 172 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 10:00:24 AM 10/31/2013 02:39:42 AM 12 MANHATTAN MANHATTAN 1001088.0 246531.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.843330 -73.939144 (40.84332975466513, -73.93914371913482)\n", "3 26595721 10/31/2013 01:56:23 AM 10/31/2013 02:21:48 AM NYPD New York City Police Department Noise - Vehicle Car/Truck Horn Street/Sidewalk 10023 WEST 72 STREET WEST 72 STREET COLUMBUS AVENUE AMSTERDAM AVENUE NaN NaN BLOCKFACE NEW YORK NaN Precinct Closed 10/31/2013 09:56:23 AM 10/31/2013 02:21:10 AM 07 MANHATTAN MANHATTAN 989730.0 222727.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.778009 -73.980213 (40.7780087446372, -73.98021349023975)\n", "4 26590930 10/31/2013 01:53:44 AM NaN DOHMH Department of Health and Mental Hygiene Rodent Condition Attracting Rodents Vacant Lot 10027 WEST 124 STREET WEST 124 STREET LENOX AVENUE ADAM CLAYTON POWELL JR BOULEVARD NaN NaN BLOCKFACE NEW YORK NaN NaN Pending 11/30/2013 01:53:44 AM 10/31/2013 01:59:54 AM 10 MANHATTAN MANHATTAN 998815.0 233545.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.807691 -73.947387 (40.80769092704951, -73.94738703491433)\n", "5 26592370 10/31/2013 01:46:52 AM NaN NYPD New York City Police Department Noise - Commercial Banging/Pounding Club/Bar/Restaurant 11372 37 AVENUE 37 AVENUE 84 STREET 85 STREET NaN NaN BLOCKFACE JACKSON HEIGHTS NaN Precinct Open 10/31/2013 09:46:52 AM NaN 03 QUEENS QUEENS 1016948.0 212540.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.749989 -73.881988 (40.7499893014072, -73.88198770727831)\n", "6 26595682 10/31/2013 01:46:40 AM NaN NYPD New York City Police Department Blocked Driveway No Access Street/Sidewalk 11419 107-50 109 STREET 109 STREET 107 AVENUE 109 AVENUE NaN NaN ADDRESS SOUTH RICHMOND HILL NaN Precinct Assigned 10/31/2013 09:46:40 AM 10/31/2013 01:59:51 AM 10 QUEENS QUEENS 1030919.0 187622.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.681533 -73.831737 (40.68153278675525, -73.83173699701601)\n", "7 26595195 10/31/2013 01:44:19 AM 10/31/2013 01:58:49 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11417 137-09 CROSSBAY BOULEVARD CROSSBAY BOULEVARD PITKIN AVENUE VAN WICKLEN ROAD NaN NaN ADDRESS OZONE PARK NaN Precinct Closed 10/31/2013 09:44:19 AM 10/31/2013 01:58:49 AM 10 QUEENS QUEENS 1027776.0 184076.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.671816 -73.843092 (40.67181584567338, -73.84309181950769)\n", "8 26590540 10/31/2013 01:44:14 AM 10/31/2013 02:28:04 AM NYPD New York City Police Department Noise - Commercial Loud Talking Club/Bar/Restaurant 10011 258 WEST 15 STREET WEST 15 STREET 7 AVENUE 8 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 09:44:14 AM 10/31/2013 02:00:56 AM 04 MANHATTAN MANHATTAN 984031.0 208847.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.739913 -74.000790 (40.73991339303542, -74.00079028612932)\n", "9 26594392 10/31/2013 01:34:41 AM 10/31/2013 02:23:51 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11225 835 NOSTRAND AVENUE NOSTRAND AVENUE UNION STREET PRESIDENT STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/31/2013 09:34:41 AM 10/31/2013 01:48:26 AM 09 BROOKLYN BROOKLYN 997941.0 182725.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.668204 -73.950648 (40.66820406598287, -73.95064760056546)\n", "10 26595176 10/31/2013 01:25:12 AM NaN NYPD New York City Police Department Noise - House of Worship Loud Music/Party House of Worship 11218 3775 18 AVENUE 18 AVENUE EAST 9 STREET EAST 8 STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Open 10/31/2013 09:25:12 AM NaN 14 BROOKLYN BROOKLYN 992726.0 170399.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.634378 -73.969462 (40.63437840816299, -73.96946177104543)\n", "11 26591982 10/31/2013 01:24:14 AM 10/31/2013 01:54:39 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10003 187 2 AVENUE 2 AVENUE EAST 11 STREET EAST 12 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 09:24:14 AM 10/31/2013 01:54:39 AM 03 MANHATTAN MANHATTAN 988110.0 205533.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.730816 -73.986073 (40.73081644089586, -73.98607265739876)\n", "12 26594169 10/31/2013 01:20:57 AM 10/31/2013 02:12:31 AM NYPD New York City Police Department Illegal Parking Double Parked Blocking Vehicle Street/Sidewalk 10029 65 EAST 99 STREET EAST 99 STREET MADISON AVENUE PARK AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 09:20:57 AM 10/31/2013 01:42:05 AM 11 MANHATTAN MANHATTAN 997470.0 226725.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.788974 -73.952259 (40.78897400211689, -73.95225898702977)\n", "13 26594391 10/31/2013 01:20:13 AM NaN NYPD New York City Police Department Noise - Vehicle Engine Idling Street/Sidewalk 10466 NaN NaN NaN NaN STRANG AVENUE AMUNDSON AVENUE INTERSECTION BRONX NaN Precinct Open 10/31/2013 09:20:13 AM NaN 12 BRONX BRONX 1029467.0 264124.0 Unspecified BRONX Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.891517 -73.836457 (40.89151738488846, -73.83645714593568)\n", "14 26590917 10/31/2013 01:19:54 AM NaN DOHMH Department of Health and Mental Hygiene Rodent Rat Sighting 1-2 Family Mixed Use Building 11219 63 STREET 63 STREET 13 AVENUE 14 AVENUE NaN NaN BLOCKFACE BROOKLYN NaN NaN Pending 11/30/2013 01:19:54 AM 10/31/2013 01:29:26 AM 10 BROOKLYN BROOKLYN 984467.0 167519.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.626477 -73.999218 (40.6264774690411, -73.99921826202639)\n", "15 26591458 10/31/2013 01:14:02 AM 10/31/2013 01:30:34 AM NYPD New York City Police Department Noise - House of Worship Loud Music/Party House of Worship 10025 NaN NaN NaN NaN WEST 99 STREET BROADWAY INTERSECTION NEW YORK NaN Precinct Closed 10/31/2013 09:14:02 AM 10/31/2013 01:30:34 AM 07 MANHATTAN MANHATTAN 992454.0 229500.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.796597 -73.970370 (40.7965967075252, -73.97036973473399)\n", "16 26594086 10/31/2013 12:54:03 AM 10/31/2013 02:16:39 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Music/Party Street/Sidewalk 10310 173 CAMPBELL AVENUE CAMPBELL AVENUE HENDERSON AVENUE WINEGAR LANE NaN NaN ADDRESS STATEN ISLAND NaN Precinct Closed 10/31/2013 08:54:03 AM 10/31/2013 02:07:14 AM 01 STATEN ISLAND STATEN ISLAND 952013.0 171076.0 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.636182 -74.116150 (40.63618202176914, -74.1161500428337)\n", "17 26595117 10/31/2013 12:52:46 AM NaN NYPD New York City Police Department Illegal Parking Posted Parking Sign Violation Street/Sidewalk 11236 NaN NaN NaN NaN ROCKAWAY PARKWAY SKIDMORE AVENUE INTERSECTION BROOKLYN NaN Precinct Open 10/31/2013 08:52:46 AM NaN 18 BROOKLYN BROOKLYN 1015289.0 169710.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.632437 -73.888173 (40.63243692394328, -73.88817263437012)\n", "18 26590389 10/31/2013 12:51:00 AM NaN DOT Department of Transportation Street Light Condition Street Light Out NaN NaN 226 42 ST E 42 ST E CHURCH AVE SNYDER AVE NaN NaN ADDRESS NaN NaN NaN Open NaN NaN Unspecified BROOKLYN BROOKLYN NaN NaN Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN\n", "19 26594210 10/31/2013 12:46:27 AM NaN NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10033 NaN NaN NaN NaN WEST 184 STREET BROADWAY INTERSECTION NEW YORK NaN Precinct Assigned 10/31/2013 08:46:27 AM 10/31/2013 01:32:41 AM 12 MANHATTAN MANHATTAN 1002294.0 249712.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.852058 -73.934776 (40.85205827756883, -73.93477640780834)\n", "20 26592932 10/31/2013 12:43:47 AM 10/31/2013 12:56:20 AM NYPD New York City Police Department Noise - House of Worship Loud Music/Party House of Worship 11216 778 PARK PLACE PARK PLACE ROGERS AVENUE NOSTRAND AVENUE NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/31/2013 08:43:47 AM 10/31/2013 12:56:20 AM 08 BROOKLYN BROOKLYN 997608.0 184656.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.673505 -73.951844 (40.67350473678714, -73.95184414979961)\n", "21 26594152 10/31/2013 12:41:17 AM 10/31/2013 01:04:37 AM NYPD New York City Police Department Noise - Commercial Banging/Pounding Store/Commercial 10016 155 E 34TH ST E 34TH ST NaN NaN NaN NaN LATLONG NEW YORK NaN Precinct Closed 10/31/2013 08:41:17 AM 10/31/2013 01:04:38 AM 06 MANHATTAN MANHATTAN 990133.0 211136.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.746194 -73.978769 (40.74619417253121, -73.97876853124392)\n", "22 26589678 10/31/2013 12:39:55 AM NaN NYPD New York City Police Department Noise - Vehicle Car/Truck Music Street/Sidewalk 11419 NaN NaN NaN NaN 112 STREET ATLANTIC AVENUE INTERSECTION SOUTH RICHMOND HILL NaN Precinct Open 10/31/2013 08:39:55 AM NaN 09 QUEENS QUEENS 1030314.0 191578.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.692394 -73.833891 (40.69239424979043, -73.8338912453996)\n", "23 26592304 10/31/2013 12:38:00 AM NaN NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11216 371 TOMPKINS AVENUE TOMPKINS AVENUE MADISON STREET PUTNAM AVENUE NaN NaN ADDRESS BROOKLYN NaN Precinct Assigned 10/31/2013 08:38:00 AM 10/31/2013 01:16:53 AM 03 BROOKLYN BROOKLYN 999720.0 188825.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.684944 -73.944221 (40.6849442562592, -73.94422078036632)\n", "24 26591892 10/31/2013 12:37:16 AM NaN NYPD New York City Police Department Blocked Driveway Partial Access Street/Sidewalk 10305 1496 BAY STREET BAY STREET LYMAN AVENUE SCHOOL ROAD NaN NaN ADDRESS STATEN ISLAND NaN Precinct Assigned 10/31/2013 08:37:16 AM 10/31/2013 12:52:10 AM 01 STATEN ISLAND STATEN ISLAND 967283.0 160518.0 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.607245 -74.061106 (40.60724493456944, -74.06110566015863)\n", "25 26591573 10/31/2013 12:35:18 AM 10/31/2013 02:41:35 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10312 24 PRINCETON LANE PRINCETON LANE HAMPTON GREEN DEAD END NaN NaN ADDRESS STATEN ISLAND NaN Precinct Closed 10/31/2013 08:35:18 AM 10/31/2013 01:45:17 AM 03 STATEN ISLAND STATEN ISLAND 929577.0 140964.0 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.553421 -74.196743 (40.55342078716953, -74.19674315017886)\n", "26 26590509 10/31/2013 12:33:00 AM NaN DOT Department of Transportation Street Light Condition Street Light Out NaN NaN 38 ST E 38 ST E CHURCH AVE LINDEN BLVD NaN NaN BLOCKFACE NaN NaN NaN Open NaN NaN Unspecified BROOKLYN BROOKLYN NaN NaN Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN\n", "27 26591379 10/31/2013 12:32:44 AM NaN DOHMH Department of Health and Mental Hygiene Harboring Bees/Wasps Bees/Wasps - Not a beekeper 3+ Family Mixed Use Building 10025 501 WEST 110 STREET WEST 110 STREET AMSTERDAM AVENUE BROADWAY NaN NaN ADDRESS NEW YORK NaN NaN Open 11/30/2013 12:32:44 AM NaN 09 MANHATTAN MANHATTAN 994143.0 231888.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.803149 -73.964266 (40.80314938553783, -73.96426608076082)\n", "28 26594085 10/31/2013 12:32:08 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10026 121 WEST 116 STREET WEST 116 STREET LENOX AVENUE 7 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Assigned 10/31/2013 08:32:08 AM 10/31/2013 02:00:57 AM 10 MANHATTAN MANHATTAN 997947.0 231613.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.802390 -73.950526 (40.80238950799943, -73.95052644123253)\n", "29 26589201 10/31/2013 12:32:00 AM NaN DOT Department of Transportation Street Light Condition Street Light Out NaN 10309 295 BAYVIEW AVENUE BAYVIEW AVENUE VAIL AVENUE BAYVIEW LANE NaN NaN ADDRESS STATEN ISLAND NaN NaN Open NaN NaN 03 STATEN ISLAND STATEN ISLAND 927687.0 127837.0 Unspecified STATEN ISLAND Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.517378 -74.203435 (40.517377871705676, -74.20343466779575)\n", "... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...\n", "111039 26428764 10/04/2013 12:17:03 AM 10/04/2013 12:38:37 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10022 249 EAST 53 STREET EAST 53 STREET 3 AVENUE 2 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:17:03 AM 10/04/2013 12:38:37 AM 06 MANHATTAN MANHATTAN 993036.0 215164.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.757248 -73.968286 (40.757247604963055, -73.96828647941395)\n", "111040 26426166 10/04/2013 12:16:22 AM 10/04/2013 05:50:49 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Store/Commercial 10029 252 EAST 110 STREET EAST 110 STREET 3 AVENUE 2 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:16:22 AM 10/04/2013 05:50:49 AM 11 MANHATTAN MANHATTAN 1000407.0 228425.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.793635 -73.941649 (40.79363516179995, -73.94164859515777)\n", "111041 26438565 10/04/2013 12:16:00 AM NaN DEP Department of Environmental Protection Noise Noise: Construction Before/After Hours (NM1) NaN 11231 480 VAN BRUNT STREET VAN BRUNT STREET REED STREET DEAD END NaN NaN ADDRESS BROOKLYN NaN NaN Open NaN NaN 06 BROOKLYN BROOKLYN 979657.0 184924.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.674249 -74.016558 (40.6742492231181, -74.01655803856313)\n", "111042 26428990 10/04/2013 12:15:52 AM 10/04/2013 12:44:52 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10014 733 WASHINGTON STREET WASHINGTON STREET BANK STREET BETHUNE STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:15:52 AM 10/04/2013 12:44:52 AM 02 MANHATTAN MANHATTAN 981950.0 207532.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.736304 -74.008299 (40.736303747410034, -74.00829935904578)\n", "111043 26432659 10/04/2013 12:15:46 AM 10/04/2013 04:18:45 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11218 1213 CORTELYOU ROAD CORTELYOU ROAD EAST 12 STREET EAST 13 STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:15:46 AM 10/04/2013 04:18:45 AM 14 BROOKLYN BROOKLYN 993451.0 172498.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.640139 -73.966847 (40.64013899178716, -73.96684680242933)\n", "111044 26426096 10/04/2013 12:14:09 AM 10/04/2013 01:03:46 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10032 539 WEST 162 STREET WEST 162 STREET ST NICHOLAS AVENUE BROADWAY NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:14:09 AM 10/04/2013 01:03:46 AM 12 MANHATTAN MANHATTAN 1000571.0 244054.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.836532 -73.941018 (40.836532082987944, -73.9410182995914)\n", "111045 26437764 10/04/2013 12:14:00 AM 10/04/2013 12:14:00 AM DEP Department of Environmental Protection Water System Dirty Water (WE) NaN 10022 251 EAST 51 STREET EAST 51 STREET 3 AVENUE 2 AVENUE NaN NaN ADDRESS NEW YORK NaN NaN Closed NaN 10/04/2013 12:14:00 AM 06 MANHATTAN MANHATTAN 992791.0 214702.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.755980 -73.969171 (40.75597977288785, -73.96917140638074)\n", "111046 26436286 10/04/2013 12:14:00 AM NaN DEP Department of Environmental Protection Noise Noise: Construction Before/After Hours (NM1) NaN 11231 480 VAN BRUNT STREET VAN BRUNT STREET REED STREET DEAD END NaN NaN ADDRESS BROOKLYN NaN NaN Open NaN NaN 06 BROOKLYN BROOKLYN 979657.0 184924.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.674249 -74.016558 (40.6742492231181, -74.01655803856313)\n", "111047 26428989 10/04/2013 12:13:08 AM 10/04/2013 02:12:47 AM NYPD New York City Police Department Illegal Parking Posted Parking Sign Violation Street/Sidewalk 11434 NaN NaN NaN NaN GUY R BREWER BOULEVARD ROCKAWAY BOULEVARD INTERSECTION JAMAICA NaN Precinct Closed 10/04/2013 08:13:08 AM 10/04/2013 02:12:47 AM 13 QUEENS QUEENS 1048801.0 178419.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.656160 -73.767353 (40.656160351546845, -73.76735262738222)\n", "111048 26430030 10/04/2013 12:12:07 AM 10/04/2013 02:45:24 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10027 215 WEST 131ST STREET WEST 131ST STREET NaN NaN NaN NaN LATLONG NEW YORK NaN Precinct Closed 10/04/2013 08:12:07 AM 10/04/2013 02:45:24 AM 01 MANHATTAN MANHATTAN 999107.0 235603.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.813339 -73.946328 (40.81333907832113, -73.94632769228208)\n", "111049 26429663 10/04/2013 12:12:07 AM 10/04/2013 01:03:44 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11209 8915 5 AVENUE 5 AVENUE 89 STREET 90 STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:12:07 AM 10/04/2013 01:03:44 AM 10 BROOKLYN BROOKLYN 976525.0 165015.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.619601 -74.027826 (40.619601147364584, -74.02782628492785)\n", "111050 26437763 10/04/2013 12:11:00 AM NaN DEP Department of Environmental Protection Noise Noise: Construction Before/After Hours (NM1) NaN 10028 NaN NaN NaN NaN EAST 84 STREET YORK AVENUE INTERSECTION NEW YORK NaN NaN Open NaN NaN 08 MANHATTAN MANHATTAN 998629.0 221493.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.774612 -73.948085 (40.77461174278734, -73.94808472177321)\n", "111051 26432955 10/04/2013 12:08:15 AM 10/04/2013 12:48:02 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10009 506 EAST 13 STREET EAST 13 STREET AVENUE A AVENUE B NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:08:15 AM 10/04/2013 12:48:03 AM 03 MANHATTAN MANHATTAN 989678.0 205065.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.729531 -73.980416 (40.72953107218499, -73.98041550317102)\n", "111052 26437035 10/04/2013 12:08:00 AM 10/04/2013 12:13:00 AM DEP Department of Environmental Protection Water System Dirty Water (WE) NaN 10022 325 EAST 54 STREET EAST 54 STREET 2 AVENUE 1 AVENUE NaN NaN ADDRESS NEW YORK NaN NaN Closed NaN 10/04/2013 12:13:00 AM 06 MANHATTAN MANHATTAN 993688.0 215099.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.757069 -73.965933 (40.75706852462872, -73.96593314322774)\n", "111053 26433197 10/04/2013 12:08:00 AM 10/04/2013 12:00:00 PM DSNY BCC - Queens East Derelict Vehicles 14 Derelict Vehicles Street 11413 220-11 145 AVENUE 145 AVENUE 221 STREET 221 STREET NaN NaN ADDRESS Springfield Gardens NaN DSNY Garage Pending NaN 10/04/2013 12:08:00 AM 13 QUEENS QUEENS 1051511.0 181411.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.664353 -73.757556 (40.6643525308449, -73.75755575708348)\n", "111054 26426060 10/04/2013 12:06:39 AM 10/04/2013 12:31:16 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11224 4823 BEACH 48 STREET BEACH 48 STREET BODY OF WATER SURF AVENUE NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:06:39 AM 10/04/2013 12:31:16 AM 13 BROOKLYN BROOKLYN 980859.0 149681.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.577515 -74.012207 (40.57751513866536, -74.01220705163807)\n", "111055 26430628 10/04/2013 12:06:28 AM 10/04/2013 12:21:39 AM NYPD New York City Police Department Noise - Commercial Loud Talking Club/Bar/Restaurant 11209 7915 3 AVENUE 3 AVENUE 79 STREET 80 STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:06:28 AM 10/04/2013 12:21:39 AM 10 BROOKLYN BROOKLYN 976189.0 168214.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.628381 -74.029040 (40.62838143294541, -74.02904041333245)\n", "111056 26431648 10/04/2013 12:06:26 AM 10/23/2013 08:14:52 AM DOT Department of Transportation Street Sign - Missing Bus Stop Street 11378 NaN NaN NaN NaN 54 AVENUE 43 STREET INTERSECTION MASPETH NaN NaN Closed 10/14/2013 09:38:47 AM 10/23/2013 08:14:52 AM 02 QUEENS QUEENS 1005171.0 206064.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.732250 -73.924513 (40.73225000573841, -73.92451289173367)\n", "111057 26437034 10/04/2013 12:06:00 AM NaN DEP Department of Environmental Protection Noise Noise: Jack Hammering (NC2) NaN 10036 NaN NaN NaN NaN WEST 48 STREET BROADWAY INTERSECTION NEW YORK NaN NaN Open NaN NaN 05 MANHATTAN MANHATTAN 988451.0 216208.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.760116 -73.984836 (40.76011648520396, -73.98483562074706)\n", "111058 26426094 10/04/2013 12:05:12 AM 10/04/2013 01:08:29 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11237 211 KNICKERBOCKER AVENUE KNICKERBOCKER AVENUE JEFFERSON STREET TROUTMAN STREET NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:05:12 AM 10/04/2013 01:08:29 AM 04 BROOKLYN BROOKLYN 1004672.0 195540.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.703365 -73.926345 (40.703365329011284, -73.92634531031759)\n", "111059 26429040 10/04/2013 12:04:52 AM 10/04/2013 03:01:04 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10003 99 2 AVENUE 2 AVENUE EAST 5 STREET EAST 6 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:04:52 AM 10/04/2013 03:01:04 AM 03 MANHATTAN MANHATTAN 987393.0 204234.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.727251 -73.988660 (40.727251287038676, -73.98866028603422)\n", "111060 26434084 10/04/2013 12:04:00 AM NaN DEP Department of Environmental Protection Noise Noise: Construction Before/After Hours (NM1) NaN 10036 NaN NaN NaN NaN 8 AVENUE WEST 47 STREET INTERSECTION NEW YORK NaN NaN Open NaN NaN 04 MANHATTAN MANHATTAN 987720.0 216313.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.760405 -73.987474 (40.76040500039782, -73.98747426235285)\n", "111061 26426164 10/04/2013 12:03:00 AM 10/04/2013 02:14:57 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 11106 30-09 BROADWAY BROADWAY 30 STREET 31 STREET NaN NaN ADDRESS ASTORIA NaN Precinct Closed 10/04/2013 08:03:00 AM 10/04/2013 02:14:57 AM 01 QUEENS QUEENS 1004746.0 217004.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.762279 -73.926013 (40.762278541098084, -73.92601303458156)\n", "111062 26439710 10/04/2013 12:03:00 AM 10/04/2013 12:03:00 AM DEP Department of Environmental Protection Water System Dirty Water (WE) NaN 10022 325 EAST 54 STREET EAST 54 STREET 2 AVENUE 1 AVENUE NaN NaN ADDRESS NEW YORK NaN NaN Closed NaN 10/04/2013 12:03:00 AM 06 MANHATTAN MANHATTAN 993688.0 215099.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.757069 -73.965933 (40.75706852462872, -73.96593314322774)\n", "111063 26435569 10/04/2013 12:02:00 AM 10/04/2013 01:10:00 AM DEP Department of Environmental Protection Water System Dirty Water (WE) NaN 10022 311 EAST 50 STREET EAST 50 STREET 2 AVENUE 1 AVENUE NaN NaN ADDRESS NEW YORK NaN NaN Closed NaN 10/04/2013 01:10:00 AM 06 MANHATTAN MANHATTAN 993118.0 214222.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.754662 -73.967992 (40.75466197318078, -73.96799173864807)\n", "111064 26426013 10/04/2013 12:01:13 AM 10/07/2013 04:07:16 PM DPR Department of Parks and Recreation Maintenance or Facility Structure - Outdoors Park 11213 NaN NaN NaN NaN NaN NaN NaN BROOKLYN NaN NaN Closed 10/18/2013 12:01:13 AM 10/07/2013 04:07:16 PM 08 BROOKLYN BROOKLYN NaN NaN Brower Park BROOKLYN Brower Park B012 NaN NaN 7189658900 Brooklyn, St. Marks, Kingston Avenues, Park Place BROOKLYN NY 11213 N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN\n", "111065 26428083 10/04/2013 12:01:05 AM 10/04/2013 02:13:50 AM NYPD New York City Police Department Illegal Parking Posted Parking Sign Violation Street/Sidewalk 11434 NaN NaN NaN NaN GUY R BREWER BOULEVARD ROCKAWAY BOULEVARD INTERSECTION JAMAICA NaN Precinct Closed 10/04/2013 08:01:05 AM 10/04/2013 02:13:50 AM 13 QUEENS QUEENS 1048801.0 178419.0 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.656160 -73.767353 (40.656160351546845, -73.76735262738222)\n", "111066 26428987 10/04/2013 12:00:45 AM 10/04/2013 01:25:01 AM NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 10016 344 EAST 28 STREET EAST 28 STREET MOUNT CARMEL PLACE 1 AVENUE NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/04/2013 08:00:45 AM 10/04/2013 01:25:01 AM 06 MANHATTAN MANHATTAN 990637.0 208987.0 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.740295 -73.976952 (40.740295354643706, -73.97695165980414)\n", "111067 26426115 10/04/2013 12:00:28 AM 10/04/2013 04:17:32 AM NYPD New York City Police Department Noise - Commercial Loud Talking Club/Bar/Restaurant 11226 1233 FLATBUSH AVENUE FLATBUSH AVENUE AVENUE D NEWKIRK AVENUE NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:00:28 AM 10/04/2013 04:17:32 AM 14 BROOKLYN BROOKLYN 996654.0 172515.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.640182 -73.955306 (40.64018174662485, -73.95530566958138)\n", "111068 26428033 10/04/2013 12:00:10 AM 10/04/2013 01:20:52 AM NYPD New York City Police Department Blocked Driveway Partial Access Street/Sidewalk 11236 1259 EAST 94 STREET EAST 94 STREET AVENUE J AVENUE K NaN NaN ADDRESS BROOKLYN NaN Precinct Closed 10/04/2013 08:00:10 AM 10/04/2013 01:20:52 AM 18 BROOKLYN BROOKLYN 1011804.0 172470.0 Unspecified BROOKLYN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.640024 -73.900717 (40.640024057399216, -73.90071711703163)\n", "\n", "[111069 rows x 52 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 2.2 Selecting columns and rows" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To select a column, we index with the name of the column, like this:" ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 Noise - Street/Sidewalk\n", "1 Illegal Parking\n", "2 Noise - Commercial\n", "3 Noise - Vehicle\n", "4 Rodent\n", "5 Noise - Commercial\n", "6 Blocked Driveway\n", "7 Noise - Commercial\n", "8 Noise - Commercial\n", "9 Noise - Commercial\n", "10 Noise - House of Worship\n", "11 Noise - Commercial\n", "12 Illegal Parking\n", "13 Noise - Vehicle\n", "14 Rodent\n", "...\n", "111054 Noise - Street/Sidewalk\n", "111055 Noise - Commercial\n", "111056 Street Sign - Missing\n", "111057 Noise\n", "111058 Noise - Commercial\n", "111059 Noise - Street/Sidewalk\n", "111060 Noise\n", "111061 Noise - Commercial\n", "111062 Water System\n", "111063 Water System\n", "111064 Maintenance or Facility\n", "111065 Illegal Parking\n", "111066 Noise - Street/Sidewalk\n", "111067 Noise - Commercial\n", "111068 Blocked Driveway\n", "Name: Complaint Type, Length: 111069, dtype: object" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints['Complaint Type']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To get the first 5 rows of a dataframe, we can use a slice: `df[:5]`.\n", "\n", "This is a great way to get a sense for what kind of information is in the dataframe -- take a minute to look at the contents and get a feel for this dataset." ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
0 26589651 10/31/2013 02:08:41 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11432 90-03 169 STREET 169 STREET 90 AVENUE 91 AVENUE NaN NaN ADDRESS JAMAICA NaN Precinct Assigned 10/31/2013 10:08:41 AM 10/31/2013 02:35:17 AM 12 QUEENS QUEENS 1042027 197389 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NNaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.708275-73.791604 (40.70827532593202, -73.79160395779721)
1 26593698 10/31/2013 02:01:04 AM NaN NYPD New York City Police Department Illegal Parking Commercial Overnight Parking Street/Sidewalk 11378 58 AVENUE 58 AVENUE 58 PLACE 59 STREET NaN NaN BLOCKFACE MASPETH NaN Precinct Open 10/31/2013 10:01:04 AM NaN 05 QUEENS QUEENS 1009349 201984 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NNaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.721041-73.909453 (40.721040535628305, -73.90945306791765)
2 26594139 10/31/2013 02:00:24 AM 10/31/2013 02:40:32 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10032 4060 BROADWAY BROADWAY WEST 171 STREET WEST 172 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 10:00:24 AM 10/31/2013 02:39:42 AM 12 MANHATTAN MANHATTAN 1001088 246531 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NNaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.843330-73.939144 (40.84332975466513, -73.93914371913482)
3 26595721 10/31/2013 01:56:23 AM 10/31/2013 02:21:48 AM NYPD New York City Police Department Noise - Vehicle Car/Truck Horn Street/Sidewalk 10023 WEST 72 STREET WEST 72 STREET COLUMBUS AVENUE AMSTERDAM AVENUE NaN NaN BLOCKFACE NEW YORK NaN Precinct Closed 10/31/2013 09:56:23 AM 10/31/2013 02:21:10 AM 07 MANHATTAN MANHATTAN 989730 222727 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NNaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.778009-73.980213 (40.7780087446372, -73.98021349023975)
4 26590930 10/31/2013 01:53:44 AM NaN DOHMH Department of Health and Mental Hygiene Rodent Condition Attracting Rodents Vacant Lot 10027 WEST 124 STREET WEST 124 STREET LENOX AVENUE ADAM CLAYTON POWELL JR BOULEVARD NaN NaN BLOCKFACE NEW YORK NaN NaN Pending 11/30/2013 01:53:44 AM 10/31/2013 01:59:54 AM 10 MANHATTAN MANHATTAN 998815 233545 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified NNaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.807691-73.947387 (40.80769092704951, -73.94738703491433)
\n", "

5 rows × 52 columns

\n", "
" ], "text/plain": [ " Unique Key Created Date Closed Date Agency Agency Name Complaint Type Descriptor Location Type Incident Zip Incident Address Street Name Cross Street 1 Cross Street 2 Intersection Street 1 Intersection Street 2 Address Type City Landmark Facility Type Status Due Date Resolution Action Updated Date Community Board Borough X Coordinate (State Plane) Y Coordinate (State Plane) Park Facility Name Park Borough School Name School Number School Region School Code School Phone Number School Address School City School State School Zip School Not Found School or Citywide Complaint Vehicle Type Taxi Company Borough Taxi Pick Up Location Bridge Highway Name Bridge Highway Direction Road Ramp Bridge Highway Segment Garage Lot Name Ferry Direction Ferry Terminal Name Latitude Longitude Location\n", "0 26589651 10/31/2013 02:08:41 AM NaN NYPD New York City Police Department Noise - Street/Sidewalk Loud Talking Street/Sidewalk 11432 90-03 169 STREET 169 STREET 90 AVENUE 91 AVENUE NaN NaN ADDRESS JAMAICA NaN Precinct Assigned 10/31/2013 10:08:41 AM 10/31/2013 02:35:17 AM 12 QUEENS QUEENS 1042027 197389 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.708275 -73.791604 (40.70827532593202, -73.79160395779721)\n", "1 26593698 10/31/2013 02:01:04 AM NaN NYPD New York City Police Department Illegal Parking Commercial Overnight Parking Street/Sidewalk 11378 58 AVENUE 58 AVENUE 58 PLACE 59 STREET NaN NaN BLOCKFACE MASPETH NaN Precinct Open 10/31/2013 10:01:04 AM NaN 05 QUEENS QUEENS 1009349 201984 Unspecified QUEENS Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.721041 -73.909453 (40.721040535628305, -73.90945306791765)\n", "2 26594139 10/31/2013 02:00:24 AM 10/31/2013 02:40:32 AM NYPD New York City Police Department Noise - Commercial Loud Music/Party Club/Bar/Restaurant 10032 4060 BROADWAY BROADWAY WEST 171 STREET WEST 172 STREET NaN NaN ADDRESS NEW YORK NaN Precinct Closed 10/31/2013 10:00:24 AM 10/31/2013 02:39:42 AM 12 MANHATTAN MANHATTAN 1001088 246531 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.843330 -73.939144 (40.84332975466513, -73.93914371913482)\n", "3 26595721 10/31/2013 01:56:23 AM 10/31/2013 02:21:48 AM NYPD New York City Police Department Noise - Vehicle Car/Truck Horn Street/Sidewalk 10023 WEST 72 STREET WEST 72 STREET COLUMBUS AVENUE AMSTERDAM AVENUE NaN NaN BLOCKFACE NEW YORK NaN Precinct Closed 10/31/2013 09:56:23 AM 10/31/2013 02:21:10 AM 07 MANHATTAN MANHATTAN 989730 222727 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.778009 -73.980213 (40.7780087446372, -73.98021349023975)\n", "4 26590930 10/31/2013 01:53:44 AM NaN DOHMH Department of Health and Mental Hygiene Rodent Condition Attracting Rodents Vacant Lot 10027 WEST 124 STREET WEST 124 STREET LENOX AVENUE ADAM CLAYTON POWELL JR BOULEVARD NaN NaN BLOCKFACE NEW YORK NaN NaN Pending 11/30/2013 01:53:44 AM 10/31/2013 01:59:54 AM 10 MANHATTAN MANHATTAN 998815 233545 Unspecified MANHATTAN Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified Unspecified N NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 40.807691 -73.947387 (40.80769092704951, -73.94738703491433)\n", "\n", "[5 rows x 52 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[:5]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We can combine these to get the first 5 rows of a column:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 Noise - Street/Sidewalk\n", "1 Illegal Parking\n", "2 Noise - Commercial\n", "3 Noise - Vehicle\n", "4 Rodent\n", "Name: Complaint Type, dtype: object" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints['Complaint Type'][:5]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "and it doesn't matter which direction we do it in:" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "0 Noise - Street/Sidewalk\n", "1 Illegal Parking\n", "2 Noise - Commercial\n", "3 Noise - Vehicle\n", "4 Rodent\n", "Name: Complaint Type, dtype: object" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[:5]['Complaint Type']" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 2.3 Selecting multiple columns" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "What if we just want to know the complaint type and the borough, but not the rest of the information? Pandas makes it really easy to select a subset of the columns: just index with list of columns you want." ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint TypeBorough
0 Noise - Street/Sidewalk QUEENS
1 Illegal Parking QUEENS
2 Noise - Commercial MANHATTAN
3 Noise - Vehicle MANHATTAN
4 Rodent MANHATTAN
5 Noise - Commercial QUEENS
6 Blocked Driveway QUEENS
7 Noise - Commercial QUEENS
8 Noise - Commercial MANHATTAN
9 Noise - Commercial BROOKLYN
10 Noise - House of Worship BROOKLYN
11 Noise - Commercial MANHATTAN
12 Illegal Parking MANHATTAN
13 Noise - Vehicle BRONX
14 Rodent BROOKLYN
15 Noise - House of Worship MANHATTAN
16 Noise - Street/Sidewalk STATEN ISLAND
17 Illegal Parking BROOKLYN
18 Street Light Condition BROOKLYN
19 Noise - Commercial MANHATTAN
20 Noise - House of Worship BROOKLYN
21 Noise - Commercial MANHATTAN
22 Noise - Vehicle QUEENS
23 Noise - Commercial BROOKLYN
24 Blocked Driveway STATEN ISLAND
25 Noise - Street/Sidewalk STATEN ISLAND
26 Street Light Condition BROOKLYN
27 Harboring Bees/Wasps MANHATTAN
28 Noise - Street/Sidewalk MANHATTAN
29 Street Light Condition STATEN ISLAND
30 Blocked Driveway STATEN ISLAND
31 Noise - Street/Sidewalk BROOKLYN
32 Taxi Complaint MANHATTAN
33 Noise - House of Worship MANHATTAN
34 Homeless Encampment MANHATTAN
35 Blocked Driveway QUEENS
36 Traffic Signal Condition BROOKLYN
37 Noise - Commercial BROOKLYN
38 Traffic Signal Condition BROOKLYN
39 Blocked Driveway QUEENS
40 Noise - Commercial QUEENS
41 Food Establishment MANHATTAN
42 Noise - Commercial BROOKLYN
43 Noise - Commercial BROOKLYN
44 Noise - Park BRONX
45 Noise - Street/Sidewalk BRONX
46 Noise - Commercial BRONX
47 Taxi Complaint MANHATTAN
48 Noise - Commercial MANHATTAN
49 Noise - Street/Sidewalk BROOKLYN
50 Noise - Commercial MANHATTAN
51 Broken Muni Meter MANHATTAN
52 Blocked Driveway BROOKLYN
53 Noise - Commercial MANHATTAN
54 Benefit Card Replacement Unspecified
55 Noise - Commercial MANHATTAN
56 Sanitation Condition BROOKLYN
57 ELECTRIC BROOKLYN
58 PLUMBING BROOKLYN
59 HEATING BRONX
......
\n", "

111069 rows × 2 columns

\n", "
" ], "text/plain": [ " Complaint Type Borough\n", "0 Noise - Street/Sidewalk QUEENS\n", "1 Illegal Parking QUEENS\n", "2 Noise - Commercial MANHATTAN\n", "3 Noise - Vehicle MANHATTAN\n", "4 Rodent MANHATTAN\n", "5 Noise - Commercial QUEENS\n", "6 Blocked Driveway QUEENS\n", "7 Noise - Commercial QUEENS\n", "8 Noise - Commercial MANHATTAN\n", "9 Noise - Commercial BROOKLYN\n", "10 Noise - House of Worship BROOKLYN\n", "11 Noise - Commercial MANHATTAN\n", "12 Illegal Parking MANHATTAN\n", "13 Noise - Vehicle BRONX\n", "14 Rodent BROOKLYN\n", "15 Noise - House of Worship MANHATTAN\n", "16 Noise - Street/Sidewalk STATEN ISLAND\n", "17 Illegal Parking BROOKLYN\n", "18 Street Light Condition BROOKLYN\n", "19 Noise - Commercial MANHATTAN\n", "20 Noise - House of Worship BROOKLYN\n", "21 Noise - Commercial MANHATTAN\n", "22 Noise - Vehicle QUEENS\n", "23 Noise - Commercial BROOKLYN\n", "24 Blocked Driveway STATEN ISLAND\n", "25 Noise - Street/Sidewalk STATEN ISLAND\n", "26 Street Light Condition BROOKLYN\n", "27 Harboring Bees/Wasps MANHATTAN\n", "28 Noise - Street/Sidewalk MANHATTAN\n", "29 Street Light Condition STATEN ISLAND\n", "30 Blocked Driveway STATEN ISLAND\n", "31 Noise - Street/Sidewalk BROOKLYN\n", "32 Taxi Complaint MANHATTAN\n", "33 Noise - House of Worship MANHATTAN\n", "34 Homeless Encampment MANHATTAN\n", "35 Blocked Driveway QUEENS\n", "36 Traffic Signal Condition BROOKLYN\n", "37 Noise - Commercial BROOKLYN\n", "38 Traffic Signal Condition BROOKLYN\n", "39 Blocked Driveway QUEENS\n", "40 Noise - Commercial QUEENS\n", "41 Food Establishment MANHATTAN\n", "42 Noise - Commercial BROOKLYN\n", "43 Noise - Commercial BROOKLYN\n", "44 Noise - Park BRONX\n", "45 Noise - Street/Sidewalk BRONX\n", "46 Noise - Commercial BRONX\n", "47 Taxi Complaint MANHATTAN\n", "48 Noise - Commercial MANHATTAN\n", "49 Noise - Street/Sidewalk BROOKLYN\n", "50 Noise - Commercial MANHATTAN\n", "51 Broken Muni Meter MANHATTAN\n", "52 Blocked Driveway BROOKLYN\n", "53 Noise - Commercial MANHATTAN\n", "54 Benefit Card Replacement Unspecified\n", "55 Noise - Commercial MANHATTAN\n", "56 Sanitation Condition BROOKLYN\n", "57 ELECTRIC BROOKLYN\n", "58 PLUMBING BROOKLYN\n", "59 HEATING BRONX\n", " ... ...\n", "\n", "[111069 rows x 2 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[['Complaint Type', 'Borough']]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "That showed us a summary, and then we can look at the first 10 rows:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Complaint TypeBorough
0 Noise - Street/Sidewalk QUEENS
1 Illegal Parking QUEENS
2 Noise - Commercial MANHATTAN
3 Noise - Vehicle MANHATTAN
4 Rodent MANHATTAN
5 Noise - Commercial QUEENS
6 Blocked Driveway QUEENS
7 Noise - Commercial QUEENS
8 Noise - Commercial MANHATTAN
9 Noise - Commercial BROOKLYN
\n", "

10 rows × 2 columns

\n", "
" ], "text/plain": [ " Complaint Type Borough\n", "0 Noise - Street/Sidewalk QUEENS\n", "1 Illegal Parking QUEENS\n", "2 Noise - Commercial MANHATTAN\n", "3 Noise - Vehicle MANHATTAN\n", "4 Rodent MANHATTAN\n", "5 Noise - Commercial QUEENS\n", "6 Blocked Driveway QUEENS\n", "7 Noise - Commercial QUEENS\n", "8 Noise - Commercial MANHATTAN\n", "9 Noise - Commercial BROOKLYN\n", "\n", "[10 rows x 2 columns]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints[['Complaint Type', 'Borough']][:10]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 2.4 What's the most common complaint type?" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "This is a really easy question to answer! There's a `.value_counts()` method that we can use:" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "HEATING 14200\n", "GENERAL CONSTRUCTION 7471\n", "Street Light Condition 7117\n", "DOF Literature Request 5797\n", "PLUMBING 5373\n", "PAINT - PLASTER 5149\n", "Blocked Driveway 4590\n", "NONCONST 3998\n", "Street Condition 3473\n", "Illegal Parking 3343\n", "Noise 3321\n", "Traffic Signal Condition 3145\n", "Dirty Conditions 2653\n", "Water System 2636\n", "Noise - Commercial 2578\n", "...\n", "Opinion for the Mayor 2\n", "Window Guard 2\n", "DFTA Literature Request 2\n", "Legal Services Provider Complaint 2\n", "Open Flame Permit 1\n", "Snow 1\n", "Municipal Parking Facility 1\n", "X-Ray Machine/Equipment 1\n", "Stalled Sites 1\n", "DHS Income Savings Requirement 1\n", "Tunnel Condition 1\n", "Highway Sign - Damaged 1\n", "Ferry Permit 1\n", "Trans Fat 1\n", "DWD 1\n", "Length: 165, dtype: int64" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaints['Complaint Type'].value_counts()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "If we just wanted the top 10 most common complaints, we can do this:" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "HEATING 14200\n", "GENERAL CONSTRUCTION 7471\n", "Street Light Condition 7117\n", "DOF Literature Request 5797\n", "PLUMBING 5373\n", "PAINT - PLASTER 5149\n", "Blocked Driveway 4590\n", "NONCONST 3998\n", "Street Condition 3473\n", "Illegal Parking 3343\n", "dtype: int64" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "complaint_counts = complaints['Complaint Type'].value_counts()\n", "complaint_counts[:10]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "But it gets better! We can plot them!" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": "iVBORw0KGgoAAAANSUhEUgAAA3UAAAGyCAYAAABDfO0FAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAIABJREFUeJzs3X9wVPW9//HXJjFESigJGMkPMXi5dQSkXuxFaVERsWG0\nVkWgU1AK1PEKZewQBC/WGRKKxmsRaOUCg4SCrXiHH4U2CgJGUChS1IwI8VcUBcLyKxB+COyGcPb7\nB9+shB+R3Xzi55yT52PGmT2fjct7XxP28N7z+XxOIBKJRAQAAAAA8KQE2wUAAAAAAOJHUwcAAAAA\nHkZTBwAAAAAeRlMHAAAAAB5GUwcAAAAAHkZTBwAAAAAeltTQkx9//LFeeuklde7cWQ899JAk6ciR\nI/rjH/+ocDis6667Tg8++KAkqbKyUosXL1YkEtGgQYOUk5MT1zgAAAAA4NI1eKXu1KlTuv/+++uN\nLV26VH369NHTTz8dbegkacGCBRo2bJiGDx+uhQsXxj0OAAAAALh0DTZ13bp1U6tWreqN7dixQ716\n9ao3FgqFlJiYqLS0NKWlpUmSampqYh4HAAAAAMSmwemX5zpx4oSOHj2qmTNn6vjx4+rXr5+uv/56\n7dmzR+3atdP8+fMlSenp6QoGg4pEIjGN5+bmGnxrAAAAAOB/MTV1LVu2VEZGhoYNG6aEhAQVFRWp\nS5cuyszM1MGDBzVmzBhFIhFNmzZNWVlZikQiMY1fzOrVq5WYmNjoNwsAAAAAXtSmTRvdeOONF3zu\nW5u6SCRS77ht27aqrq5WVlZWtNFKSUmR4zg6ceKEHMeR4zhKTk6WpJjHLyQxMVHdu3e/tHcLAAAA\nAD5TVlZ20ecaXFO3fPlyLV68WO+//77mzJkjSRo8eLBKS0s1adIk9e7dWwkJCdHx4uJizZ8/X0OH\nDo2+RqzjXrZhwwbbJfgKeZpDlmaRp1nkaRZ5mkOWZpGnWeRpjh+ybPBK3X333af77ruv3lirVq0u\n2IRdffXVGjt2bKPHAQAAAACXLhA5d36lC5WWljL9EgAAAECzVVZWpjvuuOOCzzU4/RIAAAAA4G40\ndQb5YT6um5CnOWRpFnmaRZ5mkac5ZGkWeZpFnub4IUuaOgAAAADwMNbUAQAAAIDLsaYOAAAAAHyK\nps4gP8zHdRPyNIcszSJPs8jTLPI0hyzNIk+zyNMcP2RJUwcAAAAAHsaaOgAAAABwOdbUAQAAAIBP\n0dQZ5If5uG5CnuaQpVnkaRZ5mkWe5pClWeRpFnma44csaeoAAAAAwMNYUwcAAAAALseaOgAAAADw\nKZo6g/wwH9dNyNMcsjSLPM0iT7PI0xyyNIs8zSJPc/yQJU0dAAAAAHgYa+oAAAAAwOVYUwcAAAAA\nPkVTZ5Af5uO6CXmaQ5ZmkadZ5GkWeZpDlmaRp1nkaY4fsqSpAwAAAAAPY00dAAAAALgca+oAAAAA\nwKdo6gzyw3xcNyFPc8jSLPI0izzNIk9zyNIs8jSLPM3xQ5Y0dQAAAADgYaypAwAAAACXY00dAAAA\nAPgUTZ1BfpiP6ybkaQ5ZmkWeZpGnWeRpDlmaRZ5mkac5fsgyqaEnP/74Y7300kvq3LmzHnrooej4\nqVOn9Nvf/lY///nP1a9fP0lSZWWlFi9erEgkokGDBiknJyeu8e/KnqNh7f+6xuhrOm1ztSV4zOhr\nZrRKVmbrFkZfEwAAAIB/NLim7sMPP1QoFNKnn35ar6lbsWKFPvroI3Xt2jXa1D399NMaNWqUJOnF\nF1/U+PHj4xq/kKZYU7cleEzjVnxu9DWbwh/u6qQfZqXaLgMAAACARQ2tqWvwSl23bt300Ucf1RsL\nh8P68MMPdfPNNysUCkmSQqGQEhMTlZaWFv25mpoaOY4T03hycnLs7w4AAAAAmrGY19StXLkyenWu\nzp49e9SuXTvNnz9f8+fPV3p6uoLBYMzjwNn8ML/ZLcjSLPI0izzNIk9zyNIs8jSLPM3xQ5YxNXUn\nTpzQJ598ohtuuKHeeFZWlg4ePKjBgwfrl7/8paqqqpSVlRXzeEPODnvDhg2NPj5y5Egsb90qE++X\n4+Z9vHXrVlfV4/Vj8iRPNx+Tp7njrVu3uqoerx+TJ3ly3LjjhnzrferKy8tVVlamhx56SGVlZXrt\ntdeUmpqqAwcO6PTp0xo9erRycnJUVFSkkSNHynEczZ49W08++aQkxTx+IaypY00dAAAA0JzFvaZu\n+fLl+uCDD3T48GGdPHlSjzzySLS5WrduncLhcHTXysGDB6u4uFiBQEBDhw6Nvkas4wAAAACAS/et\nV+rcgCt1zfNK3YYNG9SrVy/bZfgCWZpFnmaRp1nkaQ5ZmkWeZpGnOV7JsqErddx8HAAAAAA8jCt1\nLtecr9QBAAAAOIMrdQAAAADgUzR1cK1v27oVl44szSJPs8jTLPI0hyzNIk+zyNMcP2RJUwcAAAAA\nHsaaOpdjTR0AAAAA1tQBAAAAgE/R1MG1/DC/2S3I0izyNIs8zSJPc8jSLPI0izzN8UOWNHUAAAAA\n4GGsqXM51tQBAAAAYE0dAAAAAPgUTR1cyw/zm92CLM0iT7PI0yzyNIcszSJPs8jTHD9kSVMHAAAA\nAB7GmjqXY00dAAAAANbUAQAAAIBP0dTBtfwwv9ktyNIs8jSLPM0iT3PI0izyNIs8zfFDljR1AAAA\nAOBhrKlzOdbUAQAAAGBNHQAAAAD4FE0dXMsP85vdgizNIk+zyNMs8jSHLM0iT7PI0xw/ZElTBwAA\nAAAexpo6l2NNHQAAAADW1AEAAACAT9HUwbX8ML/ZLcjSLPI0izzNIk9zyNIs8jSLPM3xQ5Y0dQAA\nAADgYaypcznW1AEAAABgTR0AAAAA+FSDTd3HH3+sCRMm6C9/+Ut0bN68eSosLNSUKVNUXV0dHa+s\nrNS0adM0depUVVZWxj0O1PHD/Ga3IEuzyNMs8jSLPM0hS7PI0yzyNMcPWTbY1J06dUr3339/vbER\nI0Zo4sSJuvXWW7VmzZro+IIFCzRs2DANHz5cCxcujHscAAAAAHDpkhp6slu3bvroo48u+FyrVq1U\nW1srSQqFQkpMTFRaWlr0+ZqaGjmOE9N4cnJyo94M/KVXr162S/ANsjSLPM0iT7PI0xyyNIs8zSJP\nc/yQZYNNXUP++c9/6q677pIk7dmzR+3atdP8+fMlSenp6QoGg4pEIjGN5+bmNua9AAAAAECzE9dG\nKe+9956ys7OVnZ0tScrKytLBgwc1ePBg/fKXv1RVVZWysrJiHm/I2XNdN2zY0OjjI0eOxPPWrTDx\nfr14XDfmlnq8fDxr1ixX1eP1Y/IkTzcfk6e541mzZrmqHq8fkyd5uvW47rFb6rnYcUO+9ZYG5eXl\nKisr00MPPSRJ+uKLL/TOO+/owQcfrPdzRUVFGjlypBzH0ezZs/Xkk0/GNX4h3NKged7SYMOGDb64\nHO4GZGkWeZpFnmaRpzlkaRZ5mkWe5ngly4ZuadBgU7d8+XJ98MEHOnz4sDp37qxHHnlEo0ePVtu2\nbZWQkKCrrrpKI0aMkCTt2LFDS5YsUSAQ0KBBg5STkxPX+IXQ1DXPpg4AAADAGXE3dW5BU0dTBwAA\nADRn3HwcnvRtc4dx6cjSLPI0izzNIk9zyNIs8jSLPM3xQ5Y0dQAAAADgYUy/dDmmXwIAAABg+iUA\nAAAA+BRNHVzLD/Ob3YIszSJPs8jTLPI0hyzNIk+zyNMcP2RJUwcAAAAAHsaaOpdjTR0AAAAA1tQB\nAAAAgE/R1MG1/DC/2S3I0izyNIs8zSJPc8jSLPI0izzN8UOWNHUAAAAA4GGsqXM51tQBAAAAYE0d\nAAAAAPgUTR1cyw/zm92CLM0iT7PI0yzyNIcszSJPs8jTHD9kSVMHAAAAAB7GmjqXY00dAAAAANbU\nAQAAAIBP0dTBtfwwv9ktyNIs8jSLPM0iT3PI0izyNIs8zfFDljR1AAAAAOBhrKlzOdbUAQAAAGBN\nHQAAAAD4FE0dXMsP85vdgizNIk+zyNMs8jSHLM0iT7PI0xw/ZElTBwAAAAAexpo6l2NNHQAAAADW\n1AEAAACAT9HUwbX8ML/ZLcjSLPI0izzNIk9zyNIs8jSLPM3xQ5Y0dQAAAADgYaypcznW1AEAAABo\naE1dUkP/48cff6yXXnpJnTt31kMPPSRJqqys1OLFixWJRDRo0CDl5OQYHQcAAAAAXLoGp1+eOnVK\n999/f72xBQsWaNiwYRo+fLgWLlxofByo44f5zW5BlmaRp1nkaRZ5mkOWZpGnWeRpjh+ybPBKXbdu\n3fTRRx9Fj0OhkBITE5WWlhYdq6mpkeM4RsaTk5ONvCkAAAAAaC4abOrOtWfPHrVr107z58+XJKWn\npysYDCoSiRgZz83NveifvWHDBvXq1Sv6WFKjjp22F/+z3MbE++WY4zpuqcfrx3XcUo/Xj+u4pR6v\nH9dxSz1ePa4bc0s9Xj8mT/J063GvXr1cVc/Fjlu2bKmL+daNUj766CO9//77euihhxQOhzV9+nSN\nGTNGkUhE06ZNU35+viKRiJHxi12pY6MUNkoBAAAAmrNG3Xz87J6vRYsWchxHJ06c0PHjx+U4jpKT\nk42NA2c79xtnxI8szSJPs8jTLPI0hyzNIk+zyNMcP2SZ1NCTy5cv1wcffKDDhw/r5MmTeuSRRzR4\n8GAVFxcrEAho6NCh0Z81NQ4AAAAAuHTcp87lmH4JAAAAoFHTLwEAAAAA7kVTB9fyw/xmtyBLs8jT\nLPI0izzNIUuzyNMs8jTHD1nS1AEAAACAh7GmzuVYUwcAAACANXUAAAAA4FM0dXAtP8xvdguyNIs8\nzSJPs8jTHLI0izzNIk9z/JAlTR0AAAAAeBhr6lyONXUAAAAAWFMHAAAAAD5FUwfX8sP8ZrcgS7PI\n0yzyNIs8zSFLs8jTLPI0xw9Z0tQBAAAAgIexps7lWFMHAAAAgDV1AAAAAOBTNHVwLT/Mb3YLsjSL\nPM0iT7PI0xyyNIs8zSJPc/yQJU0dAAAAAHgYa+pcjjV1AAAAAFhTBwAAAAA+RVMH1/LD/Ga3IEuz\nyNMs8jSLPM0hS7PI0yzyNMcPWdLUAQAAAICHsabO5VhTBwAAAIA1dQAAAADgUzR1cC0/zG92C7I0\nizzNIk+zyNMcsjSLPM0iT3P8kCVNHQAAAAB4GGvqXI41dQAAAABYUwcAAAAAPkVTB9fyw/xmtyBL\ns8jTLPI0izzNIUuzyNMs8jTHD1nS1AEAAACAh8W9pu7dd9/V66+/rssuu0wDBgxQp06dVFlZqcWL\nFysSiWjQoEHKycmRpJjHz8WaOtbUAQAAAM1Zk6ypW7ZsmSZMmKCRI0dq8eLFkqQFCxZo2LBhGj58\nuBYuXBj92VjHAQAAAACXJu6mrmPHjvrkk0+0detWderUSeFwWImJiUpLS1NaWpokqaamRqFQKKZx\noI4f5je7BVmaRZ5mkadZ5GkOWZpFnmaRpzl+yDIp3v/xhhtu0N///nedOnVKgwYNUjAYVLt27TR/\n/nxJUnp6uoLBoCKRSEzjubm5F/zzNmzYoF69ekUfS2rUsdP2wn+OG5l4v148bu7v3+Tx1q1bXVWP\n14/JkzzdfEye5o63bt3qqnq8fkye5Mlx445btmypi4lrTd2RI0c0Y8YM/e53v5PjOCosLNQTTzyh\nF154QWPGjFEkEtG0adOUn5+vSCSi6dOnX/J4cnLyeX8ea+pYUwcAAAA0Zw2tqUuK5wUDgYDO7gUj\nkYhSUlLkOI5OnDghx3HkOE60QYt1HAAAAABwaeJaU9e6dWvdfPPNmjJliqZOnaqf/exnSkhI0ODB\ng1VcXKz58+dr6NCh0Z+PdRyQvrnsjMYjS7PI0yzyNIs8zSFLs8jTLPI0xw9ZxnWlTpL69u2rvn37\n1hu7+uqrNXbs2PN+NtZxAAAAAMClifs+dd8l1tSxpg4AAABozprkPnUAAAAAAPto6uBafpjf7BZk\naRZ5mkWeZpGnOWRpFnmaRZ7m+CFLmjoAAAAA8DDW1LmcV9bU7Tka1v6va2yX8a0yWiUrs3UL22UA\nAAAAMTF+nzrgXPu/rvFMk0xTBwAAAD9h+iXQDPhhrribkKdZ5GkWeZpDlmaRp1nkaY4fsqSpAwAA\nAAAPo6kDmoFevXrZLsFXyNMs8jSLPM0hS7PI0yzyNMcPWdLUAQAAAICH0dQBzYAf5oq7CXmaRZ5m\nkac5ZGkWeZpFnub4IUt2vwRcpiluD+G0zdWW4DGjr8ntIQAAANyBpg5wmaa7PcQBo6/WnG8P4Ye5\n925CnmaRpzlkaRZ5mkWe5vghS6ZfAgAAAICH0dQBQIz8MPfeTcjTLPI0hyzNIk+zyNMcP2RJUwcA\nAAAAHkZTBwAx8sPcezchT7PI0xyyNIs8zSJPc/yQJU0dAAAAAHgYTR0AxMgPc+/dhDzNIk9zyNIs\n8jSLPM3xQ5Y0dQAAAADgYTR1ABAjP8y9dxPyNIs8zSFLs8jTLPI0xw9Z0tQBAAAAgIfR1AFAjPww\n995NyNMs8jSHLM0iT7PI0xw/ZElTBwAAAAAeRlMHADHyw9x7NyFPs8jTHLI0izzNIk9z/JAlTR0A\nAAAAeBhNHQDEyA9z792EPM0iT3PI0izyNIs8zfFDlknx/o9HjhzRH//4R4XDYV133XV68MEHVVlZ\nqcWLFysSiWjQoEHKycmRpJjHAQAAAACXJu6mbunSperTp0+9OagLFizQqFGjJEkvvviixo8fH9c4\nALiZH+beuwl5mkWe5pClWeRpFnma44cs427qduzYoREjRkSPQ6GQEhMTlZaWFh2rqamR4zgxjScn\nJ8dbEgAAAAA0O3E1dSdOnNDRo0c1c+ZMHT9+XP369VOrVq3Url07zZ8/X5KUnp6uYDCoSCQS03hu\nbu4F/8wNGzZEu+i6ea+NOXbaXvjPcSMT77epj8nT3PGRI0fMvNHviO28bBxv3bpVI0eOdE09Xj8m\nT/J06/GsWbN0/fXXu6Yerx+TJ3m69bjusVvqudhxy5YtdTGBSCQSueizDSgqKtJvf/tbJSQkqKio\nSE888YReeOEFjRkzRpFIRNOmTVN+fr4ikYimT59+yeMXulJXWlqq7t27x1PmRW0JHtO4FZ8bfc2m\n8Ie7OumHWam2y/hW5GkOWbrfhg3ffMmExiNPs8jTHLI0izzNIk9zvJJlWVmZ7rjjjgs+lxTvi7Zt\n21bV1dXKyspSYmKiUlJS5DiOTpw4Icdx5DhOtEGLdRwA3MwLH/xeQp5mkac5ZGkWeZpFnub4Icu4\nm7rBgwfrb3/7m7788kvdfvvtSkhI0ODBg1VcXKxAIKChQ4fW+9lYxgEAAAAAlybupq5Vq1bnNWJX\nX321xo4de97PxjoOAKbsORrW/q9rjL7mkSNH9P3vf9/oa2a0SlZm6xZGX9MrvDLtxSvI0xyyNIs8\nzSJPc/yQZdxNHQB4wf6va5pojeIBo6/2h7s6NdumDgAANE6C7QIAAM2b178ddRvyNIcszSJPs8jT\nHD9kSVMHAAAAAB5GUwcAsOrs+wOh8cjTHLI0izzNIk9z/JAlTR0AAAAAeBhNHQDAKj+sZXAT8jSH\nLM0iT7PI0xw/ZMnulwCAS9YUt4hoCs35FhEAgOaHpg4AcMma7hYRZjXnW0T44X5LbkGWZpGnWeRp\njh+yZPolAAAAAHgYTR0AAD7i9W+b3YQszSJPs8jTHD9kyfRLAAAs8cIaRdYnAoD70dQBAGCJF9Yo\nsj7R+9/guwV5mkWe5vghS6ZfAgAAAICH0dQBAABcgNe/uXcb8jSLPM3xQ5Y0dQAAAADgYTR1AAAA\nF7BhwwbbJfgKeZpFnub4IUuaOgAAAADwMJo6AACAC/DDOhs3IU+zyNMcP2RJUwcAAAAAHkZTBwAA\ncAF+WGfjJuRpFnma44csufk4AADwvD1Hw9r/dY3R13Ta5mpL8JjR18xoldxsb+YOoOnQ1AEAAM/b\n/3WNxq34vAle+YDRV/vDXZ2abVPnh3VLbkKe5vghS6ZfAgAAAICH0dQBAACgyflh3ZKbkKc5fsiS\npg4AAAAAPIymDgAAAE3OD+uW3IQ8zfFDlo3aKOXUqVP67W9/q5///Ofq16+fKisrtXjxYkUiEQ0a\nNEg5OTmSFPM4AAAAAODSNOpK3Zo1a3TNNdcoEAhIkhYsWKBhw4Zp+PDhWrhwYfTnYh0HAACAv/hh\n3ZKbkKc5fsgy7it14XBYH374oW6++WaFQiGFw2ElJiYqLS0t+jM1NTVyHCem8eTk5HhLAgAAAIBm\nJ+6mbuXKlerXr58OHz4sSQoGg2rXrp3mz58vSUpPT1cwGFQkEolpPDc3tzHvBwAAAC7kh3VLbkKe\n5vghy7iauhMnTuiTTz7Rfffdp3Xr1kmSsrKydPDgQY0ZM0aRSETTpk1TVlaWIpFITOMXs2HDhmjg\ndZdIG3PstM2N561bYeL9NvUxeZo7PnLkiJk3+h2xnRd5kmdDbOflhzyPHDkiZaVKsp/Xtx17gVfy\n3HM0rIrdZ268/v3vf/+b2l12nJp4Wv/xg6ut58Uxx9/FccuWLXUxgUgkErnosxdRVlam1157Tamp\nqTpw4IBOnz6t3/zmN/rrX/+qkSNHynEczZ49W08++aQkqaioKKbxc5WWlqp79+6xltmgLcFjGrfi\nc6Ov2RT+cFcn/fD/f/i7GXmaQ5ZmkadZ5GmWF/IkS7PI0yyv5NkUzr7ggcbxSpZlZWW64447Lvhc\nXFfqunfvHm2y1q1bp3A4rKuuukqDBw9WcXGxAoGAhg4dGv35WMcBAAAAAJemUbc0kKTevXtHH199\n9dUaO3bseT8T6zgAAACAi/PClSWv8EOW3HwcAAAAADyMpg4AAADwGD/cW80t/JAlTR0AAAAAeBhN\nHQAAAOAxflgH5hZ+yJKmDgAAAAA8rNG7XwIAAAC4uD1Hw9r/dY3R1zxy5Ej0RuymZLRKVmbrFkZf\n0wu8cp+6htDUAQAAAE1o/9c1TXQz9wNGX+0Pd3Vqlk2dH9DUAQAAAPCEprjqmXrND7UleMzoa37X\nVz1p6gAAAAB4QtNd9TTru77qyUYpAAAAAOBhNHUAAAAA4GE0dQAAAADgYTR1AAAAAOBhNHUAAAAA\n4GE0dQAAAADgYTR1AAAAAOBhNHUAAAAA4GE0dQAAAADgYTR1AAAAAOBhNHUAAAAA4GE0dQAAAADg\nYTR1AAAAAOBhNHUAAAAA4GE0dQAAAADgYTR1AAAAAOBhNHUAAAAA4GE0dQAAAADgYUnx/E/z5s3T\nrl279L3vfU+//vWvlZaWpsrKSi1evFiRSESDBg1STk6OJMU8DgAAAAC4dHFdqRsxYoQmTpyoW2+9\nVWvWrJEkLViwQMOGDdPw4cO1cOHC6M/GOg4AAAAAuHRxXamr06pVK50+fVrhcFiJiYlKS0uLPldT\nUyPHcWIaT05Obkw5AAAAANDsNKqp++c//6m77rpLwWBQ7dq10/z58yVJ6enpCgaDikQiMY3n5uY2\nphwAAAAAaHbi3ijlvffeU3Z2trKzs5WVlaWDBw9q8ODB+uUvf6mqqiplZWXFPN6QDRs21Hvc2OMj\nR47E+9a/cybeb1Mfk6e5Yy9lKdnPizzJsyG28/JDnmfXaDuvbzv2AvI0izzNIk9zjhw5Yvz9NyQQ\niUQisRb5xRdf6J133tGDDz4YHSsqKtLIkSPlOI5mz56tJ598Mq7xCyktLVX37t1jLbNBW4LHNG7F\n50Zfsyn84a5O+mFWqu0yvhV5mkOWZpGnWeRplhfyJEuzyNMs8jTLC3k25yzLysp0xx13XPC5uKZf\nTps2TW3btlVhYaE6dOig4cOHa/DgwSouLlYgENDQoUOjPxvrOAAAAADg0sXV1M2YMeO8sauvvlpj\nx45t9DgAAAAA4NJx83EAAAAA8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAA\nAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA\n8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADw\nMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAAAPAwmjoAAAAA8DCaOgAAAADwMJo6AAAAAPCw\nJNsFVFZWavHixYpEIho0aJBycnJslwQAAAAAnmH9St2CBQs0bNgwDR8+XAsXLrRdDgAAAAB4itUr\ndaFQSImJiUpLS4uO1dTUKDk52WJVAAAAAOAdVpu6PXv2qF27dpo/f74kKT09XcFgULm5uTbLAgAA\nAADPCEQikYitPzwcDmv69OkaM2aMIpGIpk2bpvz8/POu1L3//vs6fPiwpSoBAAAAwK42bdroxhtv\nvOBzVq/UtWjRQo7j6MSJE3IcR47jXHDq5cWKBwAAAIDmzuqVOknasWOHlixZokAgwO6XAAAAABAj\n600dAAAAACB+1m9pAAAAAACIH00dAAAAAHgYTR0AAAAAeBhNXZxqamrqHVdUVOijjz7i1gtxCIfD\n9f4LhULRxwCA2Kxfv952CZ4WCoVsl+B5q1evtl0C8K0OHDhQ77i2tlb79++3VE3jWb2lgZdNnjxZ\n//3f/62WLVtKkubMmaNu3bpp8+bNGjZsmN3iPObZZ589b2z79u2qra3Vyy+/bKEif3j11Vf11ltv\nKSnpm7/mRUVFFivytiVLlmjAgAHR43nz5mnEiBEWK/Kempqaeretqaio0KlTp5SVlaU2bdpYrMyb\nNm3apJKSEiUmJuqxxx5TQkKCXnzxRaWmpuqWW26xXZ5nFRUVqX379urTp4+uvfZa2+V40jvvvKOf\n/vSntsvwHc7rZs2ePVt5eXn6j//4D1122WWaN2+edu3apdtuu019+/a1XV7MaOri5DhOtKGTpI4d\nO+qhhx7SM888Y7Eqb5o4caKkM5lu3LhRa9euVV5envr162e5Mm979913VVRUVO/DH/ErLy+PNnWO\n46iqqspyRd7Dl2FmrVmzRpMmTdLBgwc1ZcoURSIRDRkyRN26dbNdmqcVFhaqsrJSGzZs0N/+9jd1\n6dJFffs4nFgAAAAgAElEQVT2rXfOR8MOHTqkVatW6dwN1gOBgPLy8ixV5X2c182KRCL68ssv9d57\n72nUqFHas2ePCgoK9Nxzz9HUNScdOnTQ3r171b59e0nSqFGjtHv3bqWnp1uuzHtCoZBKS0tVVlam\nHj16aPz48WrRooXtsjyvZ8+eCgaD6tChg+1SPO2NN95QaWmpgsGgJkyYIOlMU9ezZ0/LlXkPX4aZ\n5TiOEhMTlZGRoYSEBBUUFNS7Eor4paenKyMjQ19++aV27typ+fPnq2vXrrr11lttl+YJCQkJnMeb\nAOd1syKRiAYOHKgxY8bo+PHjOn36tAKBgE6fPm27tLhwn7o4VVZWqri4WOnp6crJydHOnTtVXV2t\nESNG8JctRsOGDVMgEFCXLl2UkFB/mWd+fr6lqrxv3LhxOnr0aL0vGpimEb8ZM2Zo9OjRtsvwtDlz\n5ujnP/959MswSdq9e7dKSkr06KOPWqzMm4YOHars7GxJUjAYVFZWVvQ5/q7Hb/r06Tp27Jh+/OMf\n68c//rEuv/xySdK0adM0ZswYy9V5Q2FhYXQWDszhvG7Wq6++qnXr1ikvL0+ff/65JKl9+/bau3ev\nRo4cabm62NHUNVJVVZW++uordezYUW3btrVdjifVLUoNBAKSFJ2uEQgEdMUVV1irC4BZfBkGL9i9\ne3e0WT7b559/rk6dOlmoyHvefPNN9enTx3YZQMzOXfvtJTR1cTp7Z8ZIJBJtSCQx5SBO+/bt086d\nO9WhQwddeeWVtsvxBcdx9NVXXyk3N/e8q6CALXwZBgDx4byOi6Gpi1NhYeF5Y+zYGJ+Kigr99a9/\nVWZmZvSy9549ezRkyBD94Ac/sF2eZ23evFkrVqxQhw4dtGPHDt19993q0aOH7bI8a926derdu7c+\n+eQTvfTSS+rfv79+9KMf2S7LU/gyzKzZs2dHp60uXLhQgwcPlsRU4cZav369Vq5cqa+//lqS1Lp1\na02ePNlyVd6yevXq6O6XFRUVmjNnjtLT0zVw4ECudjYC53Wz/LabKBulxIkdG81Zvny5xowZU29L\n88OHD2vOnDkaP368xcq8bfXq1ZowYYJatGihUCikKVOm8OHfCOvXr1fv3r31zjvv6KmnntLUqVNp\n6mLE7UvM2rdvX/RxRUVF9PHBgwdtlOMbr732mgoKCrRs2TL17dtX27Zts12S59Td0iASiWjRokWa\nNGmSamtrNXPmTD3xxBO2y/Mszutm+W03UX+8CwvYsdEsLhibl5iYWC9Xpmk0TiAQ0OHDh5WWlqaW\nLVvyOxsHvgwzy3EchcNhRSKR8x4jftdcc41SUlIUDofVrl07bdq0SbfffrvtsjwlOTlZ1dXV2rRp\nk2655ZboZjNnX61H7Divm+W33URp6uL06KOPRndsLC8vV3l5efQ5dmyMzb333qupU6cqKytLmZmZ\n2rt3r4LBoIYMGWK7NE+788479fTTT0czvffee22X5Gl33HGH/vjHP0antXXs2NFyRd7Dl2FmBQKB\n6NXPhISEeo8Rv65du6q2tlY33nij8vPzddNNN9kuyXMGDBigWbNmKT09XY888oikM19CMPWycTiv\nm1VaWqply5b5ZjdR1tTF6WI7NkpSRkaGlZq8bu/evdGNUs7e8hzxcxxHwWBQ2dnZ9dYvATZw+xIA\naBzO67gYmjoAiEF1dbXS0tJsl+FJfBlm1po1a3TnnXfaLsN3Fi1aFJ05kpmZqZYtW9ouyXPO3RRJ\n+ubvPVfngabB9Ms4rVq1Snl5eZc8josjS3jBtm3bVFJSoqqqKj3//POaO3euHn74YdtleQqNm1kb\nN26kqWsC1113nQ4ePKj3339f69at0+WXX67nn3/edlmewqZIwHePpi5OK1askHT+Bh8rV66kEYkR\nWZq1dOlSPfDAA5owYcJ5z3l5rrhtJSUlevzxx/XMM89Iqr/zIC4NX+CYdejQIa1ateq8z85AIECe\njXD99dfrgw8+UFlZmX7xi1/oxz/+se2SPIdNkczivG6WX/OkqYtTQkLCBacQsEA9dmRp1t133y1J\nSklJiZ5Y0XhJSUmqqamRJB07dkypqamWK/IevsAx62KfnWi8733ve0pISFBVVZVOnDih73//+7ZL\n8hQ2RTKL87pZfs2Tpi5OeXl56t2793njoVDouy/G48jSrJSUFEnSbbfdZrkSf7nnnns0ffp07dy5\nU3PmzFH//v1tl+Q5fIFjVps2bS742YnGefvtt1VVVaWWLVtq06ZN2rJliyZNmmS7LE9hh3CzOK+b\n5dc82SgFAGIQCoWiJwTE5vXXX7/g9KuLjaNhb775pvr06WO7DN95++231b59e2VmZnJFPk4X2xQp\nEAjoiiuusFYX4Gc0dXFi1zFzyBIA4DbsdNt4+/bti96q6Morr7RdDlBPJBKpd1uIQ4cO1btnndcw\n5yVOGzdutF2Cb5Bl01iyZEm943nz5lmqxB8mTJgQ/S8/P19jx461XZLnhUIhHT161HYZnrV69ero\n44qKCo0bN05FRUX6/PPPLVblfdu2bVNRUZEmT54sSZo7d67lirynoqJCEydO1LJly7R7924tW7ZM\nEydO1GeffWa7NE/jvG7WggULoo937typadOmWaym8VhTFyd2HTOHLJtGeXm5BgwYIOnMDmRVVVWW\nK/K2s3fEOnbsmEpLSy1W401lZWVatmyZEhMTNXToUBUXFyslJUU/+clPmEYYh3feeUc//elPFYlE\ntGjRIk2aNEm1tbWaOXOmnnjiCdvleRY73Tbe8uXLNWbMGLVp0yY6dvjwYc2ZM0fjx4+3WJm3cV43\nKycnR//4xz90zTXXaOnSpZ7/spamLk7sOmYOWZr1xhtvqLS0VMFgMLpdr+M46tmzp+XK/CM1NVXH\njh2zXYbnvPrqq3rqqad05MgRjR07VrNmzVLLli1VWFhIUxeH5ORkVVdXa9OmTbrlllt0+eWXS6p/\n42fEjp1uzWB1jzmc15tG3759tWjRIi1atEi/+93vPP9vUZq6OLHrmDlkaVbfvn3Vt29fzZgxQ6NH\nj7Zdjm+cez+b7t27W6rEuxzHUYsWLZSRkaHc3Fy1atXKdkmeNmDAAM2aNUvp6el65JFHJJ3JuFOn\nTpYr8zZ2um28e++9V1OnTlVWVpYyMzO1d+9eBYNBDRkyxHZpnsR53axzz+e7du1SQUGBJG/fp46N\nUuLErmPmkCXQPAwdOlTZ2dmSpGAwqKysrOjjs9c2AG7ATreNt3fv3uhGKe3bt7ddDuBrNHWGOI6j\n8vJy/etf/9LDDz9suxxPOXf3oTqcUAHg0tWdhzZv3qxf//rXtsvxLM49jcd5HV7gOI6v7pPK9MtG\nqK2t1ZYtW/Svf/1LW7Zs0Q9/+EP16tXLdlme8+yzz2rcuHFKSvrm1/Hw4cN65ZVXNHLkSIuVAd/I\nz8/XyZMn1aZNGx06dEjf+973ovPvvTxd47v00UcfXfS5zp07f4eV+AfnIfOKioqUmZmpPn366Ac/\n+IHtcjypqKhI48aN02WXXRYd47wOtyksLFRhYaHtMoyhqYvT9OnTtW/fPl177bXq2bOnTp48qVGj\nRtkuy5NOnDhRr6GTzqyzq7t5KWKzdOlSPfDAA+fNGZdoPhrj5ptvVu/evZWRkaGjR4/qlVde0X/9\n13/ZLstTnn32WV155ZXq2rXred+O0tTFjvNQ0ygsLFRlZaXefvttLVmyRNdff73uuece22V5ysmT\nJ+s1dBLn9cbgvN40UlJSfHW1jqYuTklJSTp9+rRqa2vlOI7tcjwtJydH+/fvV0ZGRnRsz549uuKK\nKyxW5V133323pDMfVhMnTrRcjX9s3bpV9913nySpZcuW2rVrl+WKvOfFF1/Ue++9p23btiktLU2D\nBg2yXZKncR5qOunp6bryyiv15Zdfavfu3bbL8RzO62ZxXm8amZmZmjJlirp16ybJ+7fSYk1dI9TW\n1kbX0W3ZskXXXXedevXqpRtuuMF2aZ5SWVmp4uJitW3bVtnZ2dq1a5eqq6s1fPhwdejQwXZ5nrVu\n3Tp2FTXo7bff1uuvv64OHTqosrJSP/3pT3XrrbfaLstTDh48qH/+85/avXu3/v3f/119+/a1XZLn\ncR4yb/r06Tp27Jh69eqlnj17sgYsDpzXmwbndbPWrVt33piX86WpM8RxHH366afavHmzfvWrX9ku\nx5MOHDigHTt2qGPHjmrbtq3tcoDz1NbWKhgMKjs7W4mJibbL8Zxf/OIXuuqqq6K7Xp4tPz/fQkX+\nwnnIjLN3ZkXjcF4Hvjs0dQAQg+rqaqWlpdkuw5Mutp4mEAgwLQvwkXA4HH187k6YXr/BM+BWNHVx\nmj17th599FFJ0sKFCzV48GBJ0v/+7//qN7/5jc3SPOdCC3/T0tJ01113qWvXrhYq8ra6PMPhcL3d\nGlu1aqXnn3/ecnXetW3bNpWUlKiqqkrPP/+85s6dy+1L4EpTp07lyiesutCOgtu3b1dtba1efvll\nCxV5G+f1prF+/XqtXLlSX3/9tSSpdevWmjx5suWq4sdGKXHat29f9HFFRUX0cVVVlY1yPO1COzd9\n/fXXmjlzJk1dHOryXLRo0Xm7NSJ+JSUlevzxx/XMM89Iqv8ZgEvDFzhwM3YYNKduMw/HcbRx40at\nXbtWeXl56tevn+XKvInzetN47bXXVFBQoGXLlqlv377atm2b7ZIahaYuTo7jKBwOKxKJnPcYjcf0\njMY7e7fGyy+/nN0aGykpKUk1NTWSpGPHjik1NdVyRd7DFzhmnT3FrQ7nofixw6A5oVBIpaWlKisr\nU48ePTR+/HjO6wZwXjfrmmuuUUpKisLhsNq1a6dNmzbp9ttvt11W3Gjq4hQIBPTss89KkhISEuo9\nRmwu9K1oSkoK9wVqpDvuuEMTJ07U1VdfrV27dvENaSPdc889mj59unbu3Kk5c+aof//+tkvyBf6h\nF7+68w7MqNvl8rbbbrNcifc9+uijCgQC6tKli8rLy1VeXh59jqnB8eO8blbXrl1VW1urG2+8Ufn5\n+brppptsl9QorKkDfIzdGs0LhUJscR6nhr7A6d69u4WKADSFuk2R6jZIqfunJpsiNR7ndVwMTR1c\na8OGDerVq5ftMoALWr9+vW655RbbZaCZC4fDuuyyy5glYpDjOORpyL59+7Rz50516NBBV155pe1y\ngCg/fnYy/TJOZ3/jfPjwYbVp0yZ6zILq2GzatEklJSVKTEzUY489poSEBL344otKTU2lqWuEV199\nVW+99ZaSkr75a87vZuwa+v2kqYNNa9eu1ZtvvqmkpCTdf//96tatm+2SfKGwsPCCuzfi0lVUVOiv\nf/2rMjMz1b59e73//vvas2ePhgwZoh/84Ae2y/Mszutm+PWzk6YuTmf/JSosLGRRdSOsWbNGkyZN\n0sGDBzVlyhRFIhENGTLEN3/JbHn33XdVVFRU78MfseP3s+mxBX983n77bRUWFqqmpkZ/+tOf+J00\nJCUlhat1jbR8+XKNGTOm3hfehw8f1pw5czR+/HiLlXkb53Uz/PrZyW8FrHMcR4mJicrIyFBCQoIK\nCgqUnJxsuyzP69mzp4LBoDp06GC7FE/j9xNu5TiOTp06JUk6fvx4dBfmQCDABjSNkJmZqSlTpkT/\noRcIBJSXl2e5Ku9hdY95nNfN8OtnJ2vq4nT29MtgMKisrKzoMZfCYzN06FBlZ2dLIkuTxo0bp6NH\njyo9PT06Rp6x4/fTnIttwT9jxgw9/vjjFirytoKCguhGFOdi9kj81q1bd95Y7969v/M6vOyzzz7T\nX/7yF2VlZSkzM1N79+5VMBjUkCFDdO2119ouz7M4r5vh189OmjoAwHfCrydSAPWFQiFJ0oEDB/Tl\nl18qNzdXGRkZnr8SArgZTR2sW7Nmje68807bZfiS4zj66quvlJuby/oQuEIoFNJll13GVtxwrdra\n2ujnJmuX4nOhjWa2b9+u2tpavfzyyxYq8g/O67gYmjpYx0YzTWPz5s1asWKFOnTooB07dujuu+9W\njx49bJeFZsyvO47BH44dO6Z58+bp6NGjysnJUWVlpdq0aaNf/epXat26te3yPMlxHG3cuFFr167V\nv/3bv6lfv371pg4iNpzX0RC+goJ1hw4d0qpVq85bVM3i9MZZvXq1JkyYoBYtWigUCmnKlCl8+MMq\nv+44Bn9YtWqVfvKTn+hHP/pRdOyDDz7Q66+/rkGDBlmszHtCoZBKS0tVVlamHj16aPz48Uy7NIDz\nOhpCUwfrEhIS+LBvAomJifUaZaZpwDa/7jgGfygvL9eAAQPqjd1www1atmyZpYq869FHH1UgEFCX\nLl1UXl6u8vLy6HPcviR+nNfREJo6WNemTRt2FmsCd955p55++unozmP33nuv7ZLQzAUCAT377LOS\nzvxjpO6xxEYpsO+LL76ot7N1nWAwaKEab3vuueckKboxUl0jcrGNknBpOK+jIaypg3Vvvvmm+vTp\nY7sMX3IcJ7oNP9/oAQDgbZzXcTE0dYDP1E1nO1coFFJKSoqFivylurpaaWlptssAADQTnNdxKWjx\nYd3q1aujjysqKjRu3DgVFRXp888/t1iVdz377LOqra2tN3b48GH9+c9/tlSRP2zbtk1FRUWaPHmy\nJGnu3LmWKwLqe++992yXAKAJcF7/bpSUlNguoVFo6mDdO++8I+nMN1GLFi3SpEmTNHr0aC1dutRy\nZd504sSJ8+6t1KZNG+3fv99SRf5QUlKixx9/PLq1+b59+yxXBNT32muv2S4BQBPgvG5WWVnZBf97\n6623bJfWKGyUAuuSk5NVXV2tTZs26ZZbbtHll18uSQqHw5Yr86acnBzt379fGRkZ0bE9e/boiiuu\nsFiV9yUlJammpkbSmftZpaamWq4IANAccF43q7i4+IIb9N10003ffTEG0dTBugEDBmjWrFlKT0/X\nI488IunMQuBOnTpZrsyb7r77bs2aNUtt27ZVdna2du3aperqag0fPtx2aZ52zz33aPr06dq5c6fm\nzJmj/v372y4JqOe2226zXQKAJsB53awuXbpo4MCBtsswjo1SAJ86cOCAduzYoY4dO6pt27a2y/EN\nFqYDAGzgvI6G0NTBurOnWZ57LxtuSAy3OH36tBITE22XAQAAcB6mX8K6s29AXGf79u2qra3Vyy+/\nbKEi4HyTJk1SYWGh7TIANJG6G4+Hw2GdPHlSbdq00aFDh9SqVSs9//zzlqsDYNr69eu1cuVKff31\n15Kk1q1bR3e49iKaOlg3ceJESWfW0W3cuFFr165VXl6e+vXrZ7ky4BspKSlyHIebvQI+VVRUJEla\ntGiRevfurYyMDB09elSvvPKK5coANIXXXntNBQUFWrZsmfr27att27bZLqlRaOpgXSgUUmlpqcrK\nytSjRw+NHz+eaZdwnczMTE2ZMkXdunWTdGaKcF5enuWqAJi2detW3XfffZKkyy+/XLt27bJcEYCm\ncM011yglJUXhcFjt2rXTpk2bdPvtt9suK240dbDu0UcfVSAQUJcuXVReXq7y8vLoc/n5+RYrA76R\nm5ur3Nxc22UAaGJ33HGHJk6cqKuvvlq7du1i1gjgU127dlVtba1uvPFG5efne/6WBmyUAuvqbp5Z\ntznK2ZulcA8WAMB3rba2VsFgUNnZ2WyQBMATWBwC6zIyMpSRkSHHcfTVV18pEokoIyODhg4AGrB6\n9WrbJfhWUlKSUlNTaegAH6uqqqp3XFtbG73Q4EU0dbCuoqJCEydO1LJly7R7924tW7ZMEydO1Gef\nfWa7NE9bsmRJveN58+ZZqsQfJkyYEP0vPz9fY8eOtV0Smrl33nnHdgm+tG3bNhUVFUV3wZs7d67l\nioAzOK+bNWvWLG3evFmnTp2SdCbPF154QW+88YblyuLDmjpYt3z5co0ZM0Zt2rSJjh0+fFhz5szR\n+PHjLVbmbeXl5RowYICkMzuLnvuNFGJTtzOeJB07dkylpaUWqwGkQ4cOadWqVTp3FQWb+DROSUmJ\nHn/8cT3zzDOSpH379lmuCDiD87pZkUhEX375pd577z2NGjVKe/bsUUFBgZ577jn17dvXdnkxo6mD\nK7C005w33nhDpaWlCgaD0fsuOY6jnj17Wq7MP1JTU3Xs2DHbZaCZS0hIYKfgJpCUlKSamhpJZ77A\nSU1NtVwRmjvO600jEolo4MCBGjNmjI4fP67Tp08rEAjo9OnTtkuLCxulwLrPPvtMf/nLX5SVlaXM\nzEzt3btXwWBQQ4YM0bXXXmu7PM+aMWOGRo8ebbsM36g7kdbp3r27Bg4caKkaQCosLIze5xPmfPLJ\nJ1q6dKm2b9+uzp07q3///urYsaPtsgDO64a9+uqrWrdunfLy8vT5559Lktq3b6+9e/dq5MiRlquL\nHU0dXGPv3r3auXOnOnTooPbt29suBwBc7c0331SfPn1sl+FboVBIKSkptssA8B2qqalRcnKy7TLi\nQlMH6yKRSPR2BmfjhAoAFxcKhS54KxhJTMtshHPPSYcOHVJ6errFioD6+J00q7q6WmlpabbLaDTW\n1MG6oqIijRs3Tpdddll07PDhw3rllVc8efnbLV599VW99dZbSkr65q/52Zt9IDZLliyJLlCXzuyS\nNWLECIsVobn7n//5n/PGtm/frtraWr388ssWKvKHBQsWaNiwYZKknTt36sUXX9Tvf/97u0UBOrMz\na0lJiaqqqvT8889r7ty5evjhh22X5Vl+y5OmDtadPHmyXkMnSW3atPH0vULc4N1331VRUVG9pg7x\nY9cxuE3dejrHcbRx40atXbtWeXl56tevn+XKvC0nJ0f/+Mc/dM0112jp0qXcvgSuwc6sZvktT/61\nB+tycnK0f/9+ZWRkRMf27NnDzccbqWfPngoGg+rQoYPtUjyNXcfgVqFQSKWlpSorK1OPHj00fvx4\npl0a0LdvXy1atEiLFi3S7373OzKFa7Azq1l+y5M1dbCusrJSxcXFatu2rbKzs7Vr1y5VV1dr+PDh\nNCRxqGs8amtrdfTo0Xrz7pl+GT92HYPbDBs2TIFAQF26dFFCQkK95/Lz8y1V5V3n7nC7a9cuXXXV\nVZL47IQ7sDOrWX7Lk6YOrnHgwAHt2LFDHTt2VNu2bW2XAwCuVjdF/dzNUiTVm/kAwF/YSM4sv+RJ\nUwf4VFVVldq1axc9rq2t1aFDh/jHHgAAHuaX3RphVsK3/wgAL5o1a5Y2b96sU6dOSTqzW+MLL7yg\nN954w3Jl3rR+/Xo9+eSTeuyxx/TYY4/pqaeesl0SmrlVq1bFNI5LM3fu3HrHs2fPtlQJUN+2bdtU\nVFSkyZMnSzr/dxWNU1JSYruERmGjFMCnIpGIvvzyS7333nsaNWqU9uzZo4KCAj333HPq27ev7fI8\n57XXXlNBQYGWLVumvn37atu2bbZLQjO3YsUKSfWnXUrSypUrlZeXZ6MkXwgGg/WO2YkZbuG33Rpt\nKSsru+D4W2+9pXvuuec7rsYcrtQBPhWJRDRw4EB9+umnOn78uE6fPq1AIKDTp0/bLs2TrrnmGqWk\npCgcDqtdu3batGmT7ZLQzCUkJKhFixZKSUmp99+5m6YgNm3bto3+Y3n37t3c5Bmu4bfdGm0pLi7W\nF198cd5/N910k+3SGoUrdYBP3XjjjRo/frx+9rOf6aWXXlJmZqb+/ve/swlNnLp27ara2lrdeOON\nys/P9/yHP7wvLy9PvXv3Pm88FAp998X4yD333KM///nP0c0TBg8ebLskQNKZ383p06dr586dmjNn\njvr372+7JE/q0qWLBg4caLsM49goBWhGampqlJycbLsMAHC9cDjMPergSn7ZrRFmMUcDaEZo6OLn\nOI7tEoAGOY6jrVu3snmCAY7jaPfu3fy9h6vULZ+gocOF0NTBtaZOnWq7BCCqsLDQdgnAeWpra/X+\n++9r5syZGjlypNavX68ePXrYLsvTNm/erEmTJmndunUqLCzU5s2bbZcESJImTZpkuwRfY/dLAK6y\ndOlSPfDAA5owYcJ5zxUVFVmoyB9SUlLkOA6bUMA1pk+frn379unaa69Vz549dfLkSY0aNcp2WZ63\nevVqTZgwQS1atFAoFNKUKVNolOEKnIfM8OvulzR1sC4cDp83FolEmPYSp7vvvlvSmQ//iRMnWq7G\nPzIzMzVlyhR169ZNkhQIBNg2HlYlJSXp9OnTqq2t5fPSoMTExHq3ieAf0HALzkNmFBcXX3CTKa9v\ngEZTB+ueffZZ2yX4St1c+9tuu81yJf6Sm5ur3Nxc22UAUaNHj1Ztba3Ky8v1r3/9S9u3b9eMGTPU\nq1cv3XDDDbbL86w777xTTz/9tDIzM7V3717de++9tksCJHEeMoXdLwEAgGs5jqNPP/1Umzdv1q9+\n9Svb5Xia4zgKBoPKzs5WIBCwXQ4AfCuaOriO4zgqLy/X5s2b9etf/9p2OUA91dXVSktLs10GIOnM\n9PXLLruMKYIA0MxxFoArXGgHt//8z/+0XZavsJto42zbtk1FRUWaPHmyJLFtPKxbu3atJk+erN//\n/vf68MMPbZfjW17fEQ/+sWTJknrH8+bNs1SJt61atSqmca9gTR2sYwc3eEFJSYkef/xxPfPMM5Kk\nffv2Wa4Izd3bb7+twsJC1dTU6E9/+lN08wTEx6874sE/ysvLNWDAAElnZjVVVVVZrsibVqxYIUk6\nd7LiypUrPb3xDE0drGMHN7PYTbRpJCUlqaamRpJ07NgxpaamWq4IzZ3jODp16pQk6fjx4wqHw4pE\nIgoEAmrRooXl6rzHrzviwfveeOMNlZaWKhgMRm9X5DiOevbsabkyb0pISLjgZ6TXp7Gzpg6ucPYO\nblu2bNF1113HDm5xaugm2dziIH6ffPKJli5dqu3bt6tz587q37+/OnbsaLssNGMFBQUX3cSDv+ux\nmzlzJrNE4GozZszQ6NGjbZfhea+//rr69et3yeNeQVMH12EHN7hZKBSK3jYCAADADZh+CddJSEjQ\ndded/9kAAAdiSURBVNddx1xxuBINHdA8hEIh1dTUqHXr1rZLAYBvRVMH6zZt2qSSkhIlJibqscce\nU0JCgl588UWlpqbqlltusV0eIOnMrmN1C9SlM7uOjRgxwmJFAEwqKyvTsmXLlJiYqKFDh6q4uFgp\nKSn6yU9+oj59+tguD83YqlWroht4VFRUaM6cOUpPT9fAgQPVqVMny9XBLWjqYN2aNWs0adIkHTx4\nUFOmTFEkEtGQIUPYyQ2uwq5jgL+9+uqreuqpp3TkyBGNHTtWs2bNUsuWLVVYWEhTB6s2bdqkvLw8\nRSIRLVq0SJMmTVJtba1mzpypJ554wnZ5cAmaOljnOI4SExOVkZGhhIQEFRQUKDk52XZZgCR2HQOa\nC8dx1KJFC2VkZCg3N1etWrWyXRIgSUpOTlZ1dbU2bdqkW265RZdffrmkC+92jeaLjVJg3dChQ5Wd\nnS1JCgaDysrKij5XVFRkqyygHnYdA/ztYueiYDCoBQsW2CwNzVxFRYUWL16s9PR0PfLII0pISJDj\nOPq///s/DR482HZ5cAmaOgAAAADwMG/fZQ8AAAAAmjmaOlg3e/bs6OOFCxdGH8+YMcNGOb6xZMmS\nesfz5s2zVAkAAACaEhulwLp9+/ZFH1dUVEQfHzx40EY5vsFujWYsXbpUDzzwQHSTlLOx5hMAALgB\nTR2scxxH4XBYkUjkvMeIHbs1mnX33XdLOnPT8YkTJ1quBgAA4HxslALrCgoKFAgELvgc/4iOH7s1\nmrVu3Tr17t3bdhkAAADnoakDAAAAAA9j+iWsa+jmmS1atPgOK/GnQ4cOKT093XYZAAAAaCI0dbCu\nqKjovOmX27dvV21trV5++WVLVXnftm3bVFJSoqqqKj3//POaO3euHn74Ydtl+cbUqVOVn59vuwwA\nAACaOthXUFAg6cxmHhs3btTatWuVl5enfv362S3M40pKSvT444/rmWeekVR/l1EAAAD4B00drAuF\nQiotLVVZWZl69Oih8ePHM+3SgKSkJNXU1EiSjh07ptTUVMsVedOFpgezOysAAHATNkqBdcOGDVMg\nEFCXLl2UkJBQ7zmmt8Xvk08+0dKlS7V9+3Z17txZ/fv3V8eOHW2X5TmFhYUXfY7dWQEAgBvQ1MG6\n/fv3S5ICgYDO/XXMyMiwUZKvhEIhpaSk2C4DAAAATYSmDvC56upqpaWl2S4DAAAATSTh238EaFqz\nZ8+OPl64cGH08YwZM2yU4xvbtm1TUVGRJk+eLEmaO3eu5YoAAADQFGjqYN3ZuzJWVFREHx88eNBG\nOb5Rt/tl69atJbH7JQAAgF+x+yWscxxH4XA4uqPg2Y8RP3a/BAAAaB5YUwfrCgoKzrv5eB12F4wf\nu18C+H/t3b1LK2kYhvE7iF+IGsaARkMgINiJhY2IYJd/INqICBYWYmOjWAVim1KUEzCNnYixTEDB\n0kYQJE1UkJAMEQIRPwq/twgbjpyzIMvuvr6z16/KTHW1T+adZwAA/w8MdYDHsf0SAADA2xjqYNzL\ny4uam5sb15eXl3p+ftbAwIC6u7sNltnt7e1NTU1NpjMAAADwL2NRCoxbX1/X4+Nj4/rHjx86PT1V\nJpMxWGW/RCJhOsETkslk4/f+/r7BEgAAgN9jqINx7+/v6ujoaFxHIhHNzs7KdV2DVfZra2tj2cw/\n4Oc/HM7Pzw2WAAAA/B7bL2FcOBxWpVJRX1+fJGlxcVHlclmO4xgus1swGFQymdTw8LAkyefzKRqN\nGq6yz19tZ/X5fGptbTWdBwAAwDt1MK9UKml7e1uO4ygUCqlYLKpWq2l+fl7hcNh0nrWOj49/uTc5\nOfmfd9iO7awAAOC7Y6jDt1GtVnV9fa1IJKKenh7TOQAAAIAVGOoA4Atubm5ULBYVDofV29trOgcA\nAKCBRSmAR+3t7X26TqfThkrsdnFxoXg8rkwmo3K5rEwmo3g8rkKhYDoNAABAEotSAM/K5/OKxWKS\n6ss+qtWq4SI7HRwcaHl5WX6/v3Hv9vZWqVRKKysrBssAAADqGOoAjzk8PNTR0ZFc19Xa2pqk+lA3\nNjZmuMxenFIHAADfGe/UAR61sbGhpaUl0xnWKxQK2tnZUX9/v4LBoCqVilzX1czMjIaGhkznAQAA\nMNQBwFdUKpXGopQ/v6kIAADwHXD8EgC+IBAI6OHhQYFAwHQKAADAJzypAzwml8spGo1Kqm9uTKVS\nchxHU1NTGhwcNFxnn/v7e6XTad3d3SkUCqlUKsnv92tubk5dXV2m8wAAAHhSB3jNycmJotGoPj4+\ntLu7q0QiodfXV21ubmp1ddV0nnVyuZzGx8c1OjrauHd2dqZsNqvp6WmDZQAAAHV8pw7wmJaWFtVq\nNWWzWU1MTKi9vV2dnZ16enoynWalfD7/aaCTpJGREeXzeUNFAAAAn/GkDvCYWCymra0tOY6jhYUF\nSfVPGnD08u+5urpqfBriZ67rGqgBAAD4Fe/UAQAAAIDFOH4JAAAAABZjqAMAAAAAizHUAQAAAIDF\nGOoAAAAAwGIMdQAAAABgsT8AcS4QVBUGV18AAAAASUVORK5CYII=\n", "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "complaint_counts[:10].plot(kind='bar')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "